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!