VLOOKUP w/ 2 or more conditions
 

I need to have VLOOKUP be able to look up first, a Purchase Order # in column
A, and then also the part # in column E, and then list the quantity received
from another workbook, that pivots this information. How do I give the
VLOOKUP 2 conditions?
Thanks for your time!

VLOOKUP w/ 2 or more conditions
 

You can't, you need index and match

=INDEX(Quantity_Range,MATCH(1,(A2:A50=PO#)*(E2:E50 =part#),0))

entered with ctrl + shift & enter

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Jaye" wrote in message
...
I need to have VLOOKUP be able to look up first, a Purchase Order # in
column
A, and then also the part # in column E, and then list the quantity
received
from another workbook, that pivots this information. How do I give the
VLOOKUP 2 conditions?
Thanks for your time!