Reverse Find And Replace?

[whollycow]

Hi, 

So the Find and Replace function allows you to check if the value is Data A in inside a column in Data B and then allows you to append a new column in Data B. How do I add the column in Data A instead? 

If the value in Data A is found in a column in Data B, I want it to return a value from Data B into Data A. Please help! 

Data A

Data B

[AbhilashR · Accepted solution]

Hi @whollycow, would an approach like this apply to your larger dataset? Appending the two datasets is an inefficient approach, but if your data isn't large enough this might get you to your destination.

I hope this helps.

[DavidP]

How about using Text to Rows on Product SKU so that every row just contains a single value and then use Find Replace as normal?