A combination of SUMPRODCUT/ISNUMBER with LOOKUP

- - Latest reply: ac3mark
Posts
10940
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
December 14, 2018
- Nov 1, 2018 at 05:10 PM
Hello all, hoping someone can help

CELL (A)
I have a question where, I have a column of data where there is a missmatch of data.

CELL (B)
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)

CELL (C)
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


hope you guys can help
See more 

Your reply

1 reply

Posts
10940
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
December 14, 2018
0
Thank you
What do you have already? Post your code here and we can help out!

Respond to ac3mark