Link to home
Start Free TrialLog in
Avatar of ssblue
ssblueFlag for United States of America

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
ASKER CERTIFIED SOLUTION
Avatar of Ben Personick (Previously QCubed)
Ben Personick (Previously QCubed)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Nice work Ben!
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:
=INDEX(Type!B:B,MATCH(INDEX(Category!B:B, MATCH(C2,Category!A:A,0)),Type!A:A,0))

Open in new window

OrderType_b.xlsx
Avatar of ssblue

ASKER

Sorry for the delay. Thanks!
Glad to help!  Have a good one SSBlue :)