Problem:
In a cell in workbook 1 i need to search what is in red to match with workbook 2. If match is found, it copies the values in workbook 2 (B2,B3,B4) which contains "Sammy 20" into workbook 1 (B2,B3,B4).
What formula/logical formula to use to that it does this kind of search.
The attached file has a better view of the problem. I am using Excel 2007 but had it saved at 2003 so that those w/o 2007 can view it too.
Workbook 1:
"Sammy 20 attached"
Workbook 2:
"Sammy 20 175cm"
"Sammy 20 drives"
"Sammy 20 own a house"
"David 30 120cm"
"David 30 drinks"
Bookmarks