We help IT Professionals succeed at work.

Excel - look up and match to reurn data

174 Views
Last Modified: 2017-05-01
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
Comment
Watch Question

Lead SaaS Infrastructure Engineer
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Edward PamiasTeam Lead RRS Desk
Top Expert 2016

Commented:
Nice work Ben!
Ben Personick (Previously QCubed)Lead SaaS Infrastructure Engineer
CERTIFIED EXPERT

Commented:
Thank you Edward :)
Ryan ChongSoftware Tead Lead / Business Analyst / System Analyst / Data Engineer / Applications Consultant
CERTIFIED EXPERT

Commented:
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
ssblueCoordinator

Author

Commented:
Sorry for the delay. Thanks!
Ben Personick (Previously QCubed)Lead SaaS Infrastructure Engineer
CERTIFIED EXPERT

Commented:
Glad to help!  Have a good one SSBlue :)
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.