If by chance you mean a double lookup, where you have 2 key columns and you
want to match both and get the adjacent value in another column, you can use
=INDEX(C1:C100, MATCH(D1&D2,A1:A100&B1:B100,0))
which is also an array formula, so commit with Ctrl-Shift-Enter.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"cmart02" wrote in message
...
I'm not sure if this is what you want, but... YOu can try:
=IF(ISERR(INDEX(B1:B8,SMALL(IF(A1:A8=C2,ROW(A1:A8) ,""),ROW(A1:A8)))),"",INDE
X(B1:B8,SMALL(IF(A1:A8=C2,ROW(A1:A8),""),ROW(A1:A8 ))))}
Press CTRL+SHIFT+ENTER after all that...
Regards,
Robert
"Rody" wrote:
How do I get to run a multiple VLOOKUP?
Thanks
|