Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup with 3 or more conditions | Excel Worksheet Functions | |||
How do you do a VLookup with two conditions? | Excel Worksheet Functions | |||
Vlookup using 2 conditions | Excel Discussion (Misc queries) | |||
How:iserror vlookup & count no. times value shows with conditions | Excel Worksheet Functions | |||
Vlookup with multiple conditions | Excel Worksheet Functions |