A combination of SUMPRODCUT/ISNUMBER with LOOKUP

Closed
Trinilad - Nov 1, 2018 at 12:18 PM
 Blocked Profile - 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
Related:

1 response

Blocked Profile
Nov 1, 2018 at 05:10 PM
What do you have already? Post your code here and we can help out!

0