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)))),"",INDEX(B1:B8,SMALL(IF(A1:A8=C 2,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
|