look up based on multiple dropdowns

**nellyc** · 06-13-2013, 07:09 AM

Hi all

Im a little lost again

How can I return a cell value based on the multiple drop downs on the attached?

I have tried index / match but can not get it to work with multiple criteria.

thanks in advance

Nelly

**Ace_XL** · 06-13-2013, 07:20 AM

Try this array formula

=INDEX($F$4:$I$25,MATCH(1,($A$4:$A$25=K4)*($B$4:$B$25=L4)*($C$4:$C$25=M4)*($E$4:$E$25=N4),0),MATCH(O4,$F$3:$I$3,0))

Confirm with Ctrl+Shift+Enter and not just Enter