Example.xlsx
Hey All,
I was wondering if someone could help me with an advanced matching / look up formula for a specific scenario.
I think I have to combine the VLOOKUP, IF and Match functions but Im not sure how to set it up.
In the attached is a small example but for the project there are 1000's of record.
I need to lookup the company name in Tab 1 and match it with Tab 2. Then in tab 2 under each product, map the proper version for that product from tab 1.
Anyone have a formula idea for this?
I appreciate all of your time!
Thanks,
-A
Bookmarks