Vlookup, index or match?

[cwallace70]

I have a spreadsheet that I am trying to get and exact match on a summary page. The criterias are
if the data in B3 & C3 matches the data on a separate tab but same cell references then the data from cells F3:BR3 should be exact for all for all cells that have the exact same criteria as B3 & C3. To explain myself further. If a cell b3 have a # of 00057 and cell C3 have a nuber of 058 then all cells in those two columns that match those criteria should have the same percentage from column F5:BR2631.

This is an index formula I am trying and I am getting #VALUE! ERROR.
=INDEX($B$3&$C$3,MATCH(BASE!B4&BASE!C4,BASE!F4:BR2632,0))

Would VLOOKUP or Match be better and can someone assist me with the formula.
Thanks

 

[snb_]

You also need a column:

=INDEX($B$3&$C$3,MATCH(BASE!B4&BASE!C4,BASE!F4:BR2632,0),1)

 

[T. Valko]

You also need a column:
=INDEX($B$3&$C$3,MATCH(BASE!B4&BASE!C4,BASE!F4:BR2632,0),1)

I don't understand what the OP is wanting to do but neither of your formulas will work because in the MATCH function the lookup_array argument must be a 1 dimensional array (single row or single column).

 

[Aladin Akyurek]

I have a spreadsheet that I am trying to get and exact match on a summary page. The criterias are
if the data in B3 & C3 matches the data on a separate tab but same cell references then the data from cells F3:BR3 should be exact for all for all cells that have the exact same criteria as B3 & C3. To explain myself further. If a cell b3 have a # of 00057 and cell C3 have a nuber of 058 then all cells in those two columns that match those criteria should have the same percentage from column F5:BR2631.

This is an index formula I am trying and I am getting #VALUE! ERROR.
=INDEX($B$3&$C$3,MATCH(BASE!B4&BASE!C4,BASE!F4:BR2632,0))

Would VLOOKUP or Match be better and can someone assist me with the formula.
Thanks

Care to post a very small sample table, the look up values, and the results which must obtain?

 

[tigeravatar]

Cross posted here:
Vlookup, Index or Match?