Hi all the Excel Guru out there,
I have a huge table with over 20k vendors on it. A lot of them have the same name, or same address. I need to use a formula that will give me the correct vendor ID when I enter the name & address on a work sheet. I've created an example here. Right now I'm using "Find" to paste the name and look up the addresses and it takes forever to get the vendor ID. Please help save my day!
Bookmarks