Vacuum example.xlsx
Hi, this should be simple.... only I'm struggling!
I have sheet 1 with a row of manufacturer names in column A
Hoover International
Hoover UK
Numatic
Numatic International
Bosch GB
Bosch EU
BSCH (INT)
NMTC
In sheet 2 I have the search terms and the results in A & B
A : B
Hoover : Hoover
Bosch : Bosch
BSCH : BOSCH
NMTC : NUMATIC
Numatic : NUMATIC
I would like a search of sheet 1 with the text in sheet 2. If there's a match, column B will be put next to the text in culumn A like:
A : B
Hoover International: HOOVER
Hoover UK : HOOVER
Numatic : NUMATIC
Numatic International: NUMATIC
Bosch GB : BOSCH
Bosch EU : BOSCH
BSCH (INT) : BOSCH
NMTC : NUMATIC
Thanks!
Bookmarks