PDA

View Full Version : Solved: Multi value lookup



Aussiebear
02-03-2010, 12:25 AM
I currently have two datavalidated 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?

Bob Phillips
02-03-2010, 01:21 AM
Ted, this ARRAY formula does it

=INDEX(C:C,MATCH(1,($A$1:$A$20=$H$2)*($B$2:$B$20=$H$3),0))

Aussiebear
02-03-2010, 04:06 AM
being an array, I'll need to enter it with Ctrl,Shift,Enter?

Bob Phillips
02-03-2010, 06:13 AM
Correct.