Link to home
Start Free TrialLog in
Avatar of nts42a
nts42aFlag for United States of America

asked on

Unable to Search Merged Cells with V-lookup in Excel 2007

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.
 Example-1.xlsx
ASKER CERTIFIED SOLUTION
Avatar of roger_karam
roger_karam
Flag of Brazil image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
oh, and after unmerging use a Pivot Table with the values you want to see in Column - this will show both values while using vlookup will still only return the first.

Sincerely,
RK
Avatar of nts42a

ASKER

Well, that was a start. It did unmerge the cells, and copied some of the data to blank cells. However, it leaves a significant number empty. Example-2.xlsx
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of nts42a

ASKER

I would also like to thank matthewspatrick for "Title if null excel"
Thanks for the points nts42a! Sorry i missed the blank cells.

sincerely,
RK