Hi Forum
I have a table "Data" with a "Date" and "Description" column in the sheet "Data".
In the sheet "Keywords" I have the table "Keywords" with columns called "Code" and "Keyword".
Now, I need to search the "Description" column for the values in the column "Code" in the "Keywords"-table. If a match is found, then the "code" part of the string should be replaced with the content of the cell in the Keyword-column.
An example - please also see attached sample workbook:
"Data" table in sheet "Data":
Date - Description
01-03-2013 - Bla bla bla 287494940 4107683F
05-03-2013 - Bla bla bla Aft859065384 06590888K
06-03-2013 - Bla bla bla 103206 2688077F
"Keywords" table in sheet "Keywords"
Code - Keyword
4107683F - Shop A
06590888K - Shop B
2688077F - Shop C
After running the code, the "Data" table in sheet "Data" should look like this:
01-03-2013 - Bla bla bla 287494940 Shop A
05-03-2013 - Bla bla bla Aft859065384 Shop B
06-03-2013 - Bla bla bla 103206 Shop C
In my "Data" table, there can be multiple rows with the same "Code" that needs to be replaced with the "Keyword" value. E.g. multiple rows in the "Data" table can contain "4107683F" that needs to be replaced with "Shop A".
Hope you Excel wizards can point me in the right direction - I've toyed around with Find and replace, but can't seem to find any posts on how to loop through two ranges and replace values.