I receive quarterly database update files up to 20,000 rows long. Column A contains some merged cells. I need to perform v-lookups to compare my data to their file information in column B & C. This gives me all the applicable rev codes for any given procedure code.
1) How do I perform a v-lookup with multiple results possible?
2) Is there a way to un-merge the cells in column A and duplicate the correct procedure code into the newly created blank cells?
I greatly appreciate any assistance, and there is no rush.