Multiple VLOOKUP

C

cmart02

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=C2,ROW(A1:A8),""),ROW(A1:A8))))}

Press CTRL+SHIFT+ENTER after all that...

Regards,
Robert
 
B

Bob Phillips

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can I add a formula or function to Vlookup? 1
Help With VLOOKUP 2
Vlookup a subtotal 2
Tracked changes by multiple people modified to one 0
vlookup formatting problem 1
Dragging a formula down isn't working - where am I going wrong? 1
VLOOKUP & Data Validation 0
Multiple VLOOKUP in an IF statement 2

Top