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