Find and Replace, but return all matches?

[lmanda]

Hi all,

I am trying to find a way to see if a column contains a value, return all the corresponding values from another column?

My current workflow (also attached)...:

For each Combo, find replace only returns one account:

How can I make it return all accounts that correspond to the Combo? I.e. return both 82463 and 82486 for AP, and 12345 and 23456 for HA?

[atcodedog05 · Accepted solution]

Hi @lmanda 

In your scenario, you can use a join tool instead.

Workflow:

Find and replace will always only return the first match.

Hope this helps : )

[lmanda]

ah!! thank you so much! *much simpler than I was thinking in my head* 😅 lol, thanks again

[atcodedog05]

Happy to help : ) @lmanda 

Cheers and have a nice day!