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?
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?
=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.
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.
SHAZAM!
So obvious, but nice! I like it.Originally Posted by Shazam