Please see excel spreadsheet attached- it has 2 tabs.
Tab 1 – Jan-Sept –Lauren info
Tab 2-AB vins unpaid –Andre info
I need to populate column H of my tab with description “AB list.” as per the VIN and part number in his spreadsheet-column C and D on his tab
The ones in yellow on his spreadsheet I did manually & populated column H on my spreadsheet by typing in myself
So lets take an example
On his tab the first vin and part number is below
I located that vin and part number on my tab on row 26420 where I manually typed in AB list in column H
Is there a function in excel I can use to not have to do this manually?
Hi,
I am an Excel Expert with very good knowledge of VBA and formula. I can do this task.
Please come on chat for more details.
Thank you
Awaiting your response.
The answer to your problem Is a couple of simple Formulas. To better Understand your problem I opened your provided spreadsheet. The problem turned out to be so simple I have already contemplated the task. If you accept my bid I will send you my version of your spreed sheet and show you what I have done and how you can replicate it in the future as you continue to add more data.