PDA

View Full Version : Solved: Index, Vlookup Function??



pico
11-20-2006, 02:25 PM
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
11-20-2006, 02:34 PM
I have attached your solution.

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

Bob Phillips
11-20-2006, 03:09 PM
=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
11-20-2006, 05:11 PM
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
11-21-2006, 02:33 AM
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.