Hi, after searching the net for days without much of a clue exactly what I'm looking for I found this place, a quick look at the first 10 pages started to make my brain explode. hopefully I can get some help.
What I need to do is search all the cells containing data in column A one at a time and when a match is found in column E copy the data found in E and paste it into a 3rd row.
The length of the list in column A can vary in size generally about 40-400 rows. Each cell contains unique data being compared to a master list(~100,000) in column E with extra data that is needed.
The sample attached has before and after sheets named raw and completed.
Thanks
-Jesper
Bookmarks