VLOOKUP w/ 2 or more conditions

J

Jaye

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!
 
P

Peo Sjoblom

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
 
Top