I currently have two data validated cells (H2 & H3) which will determine the lookup values across a small range A1:C9 and then return a value to H4. Can a Lookup have more than one value?
Printable View
I currently have two data validated cells (H2 & H3) which will determine the lookup values across a small range A1:C9 and then return a value to H4. Can a Lookup have more than one value?
Ted, this ARRAY formula does it
=INDEX(C:C,MATCH(1,($A$1:$A$20=$H$2)*($B$2:$B$20=$H$3),0))
being an array, I'll need to enter it with Ctrl,Shift,Enter?
Correct.