ssblue
asked on
Excel - look up and match to reurn data
I have a file where I need to find the ORDER TYPE
step 1: match WBS on Orders Tab to WBS on Category Tab to get CATEGORY
step 2: match Category on Category Tab to Category on Type Tab to get Type
Step 3: Using WBS match on Orders tab fill in Type.
See attachement
OrderType.xlsx
step 1: match WBS on Orders Tab to WBS on Category Tab to get CATEGORY
step 2: match Category on Category Tab to Category on Type Tab to get Type
Step 3: Using WBS match on Orders tab fill in Type.
See attachement
OrderType.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Nice work Ben!
Thank you Edward :)
in case the matched value's column is in front of compare value's column, you can use Index + Match for values comparison.
in Cell B2, you can use this formula as well:
in Cell B2, you can use this formula as well:
=INDEX(Type!B:B,MATCH(INDEX(Category!B:B, MATCH(C2,Category!A:A,0)),Type!A:A,0))
OrderType_b.xlsx
ASKER
Sorry for the delay. Thanks!
Glad to help! Have a good one SSBlue :)