I have a large spreadsheet containing thousands of medical provider names on one tab, and about 100 retained experts on another tab. How can I get Excel to search the first tab of thousands of providers using what is in the 2nd tab of retained experts?
My ideas: could I record a macro of me searching the chart with each name, and for any matches have the cell turn yellow? That seems rather time consuming to record the macro.
I thought maybe a vlookup table, but not sure how I would set that up.
Any help would be appreciated!
Bookmarks