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,


[TABLE="class: grid, width: 500, align: center"]
<TBODY>[TR]
[TD]VSC[/TD]
[TD]BICEEPR[/TD]
[TD]REL DEPT[/TD]
[TD]FGA[/TD]
[TD]FGA Name[/TD]
[/TR]
[TR]
[TD]2008000[/TD]
[TD]Body[/TD]
[TD]1619[/TD]
[TD]PIA1[/TD]
[TD]FRONT AND UNDERBODY STRUCTURE[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]

 

[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!