Require macro for the attached scenario

[jyoti_k23]

1064610646

Hi, I need to create a macro.. to match the "input" column with the invalid values in the "lookup table" and create a new column as "output" where the invalid values are replaced with valid values(please refer to the excel for the data and scenario.)

Thanks in advance

[Kenneth Hobs]

Welcome to the forum!

This will involve parsing each word and then using sort of an =vLookup() method. If no solution is posted before I get back to this, I will post one for you.