Solved: Index, Vlookup Function??

[pico]

I have a table of boolean values as denoted in the attached file. I would like to output a partnumber based on the three different boolean outputs( FIRE, HWY ACCESS and Key Operated). Is there a way i can do this?

[CBrine]

I have attached your solution.

HTH
Cal
PS-I've hidden column G, which is the index for the multiple criteria vlookup.

[Bob Phillips]

=INDEX($G$4:$G$11,MATCH(1,($D$4:$D$11=$B$4)*($E$4:$E$11=$B$5)*($F$4:$F$11=$ B$6),0))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter.

[Shazam]

See if this helps.

non-array approach

=INDEX($G$4:$G$11,MATCH(1,INDEX(($D$4:$D$11=$B$4)*($E$4:$E$11=$B$5)*($F$4:$ F$11=B6),0,1),0))


Hit enter.

[Bob Phillips]

See if this helps.

non-array approach

=INDEX($G$4:$G$11,MATCH(1,INDEX(($D$4:$D$11=$B$4)*($E$4:$E$11=$B$5)*($F$4:$ F$11=B6),0,1),0))


Hit enter.

So obvious, but nice! I like it.