Index match help...

[wisemank]

Hi,

I have a complex situation and need to mine data for 3 conditions for an exact match. I currently use the VSC column of data in a vlookup formula to map the FGA then again to map the FGA Name, but the results are less than %80 accurate because of the vlookup restrictions. I want to include the BICEEPR and REL Dept in the lookup to obtain more accurate findings. My current formula is (=VLOOKUP(B3,Sheet2!A:K,8,FALSE) using only the VSC column. How do I add the other fields to an index match formula to find the FGA results? Many thanks,

VSC	BICEEPR	REL DEPT	FGA	FGA Name
2008000	Body	1619	PIA1	FRONT AND UNDERBODY STRUCTURE

<TBODY>
</TBODY>

 

[Aladin Akyurek]

Looks like...
Control+shift+enter, not just enter:

=INDEX(Sheet2!$H$2:$H$100,
  MATCH(1,IF(Sheet2!$A$2:$A$100=$B3,
  IF(Sheet2!$B$2:$B$100=$C3,IF(Sheet2!$C$2:$C$100=$D3,1))),0))

if my presuppositions hold!