Reverse Find And Replace?

Question

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 Answer

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.