I have a question where, I have a column of data where there is a missmatch of data.
I have a seperate list where I want to say, look in CELL (A) and then check to see if this word exists in CELL (B)
If this is true, I then want to look into a table and return the assigned vale. i.e (protract) - returns (complete by Contract)
eg CELL (A) - (protract 6153)
CELL (B) - (protract)
CELL (C) checking the word found against the lookup table in this instance (protract - Complete by Contract)
CELL (D) (protract 6153) is replaced by (complete by Contract)
It should be noted that there are more than 1 word to find in the column, but each cell only has one word to find