Vlookup/ replace multiple fields

[Apwc]

Is there a way to Vlookup/ replace multiple fields, have been doing "Find Replace" but there are over 50 fields, if there is a single tool to perform that function instead of 50 "Find replace" that would be awesome! Thank you.

NY	WI	CA	DE	HI
111	AAA	AAA	AAA	AAA
222	AAA	AAA	999	AAA
AAA	333	AAA	AAA	666
888	777	444	555	AAA
AAA	AAA	AAA	AAA	AAA

111	Yes
222	No
333	No
444	Yes
555	No
666	Yes
777	No
888	Yes
999	No

Result

NY	WI	CA	DE	HI
Yes	AAA	AAA	AAA	AAA
No	AAA	AAA	No	AAA
AAA	No	AAA	AAA	Yes
Yes	No	Yes	No	AAA
AAA	AAA	AAA	AAA	AAA

[binuacs]

@Apwc one way of doing this with the find and replace tool

[Apwc]

Thank you! That is very helpful! That solve my problem, but just curious, what if I only need to replace it for NY, CA and HI? Is there a way to do that as well? 

[bgreedy]

Hi,

One option is to transpose the data to consolidate all the values into a single column, find and replace, then cross-tab to revert the table back 

Example workflow attatched

[binuacs · Accepted solution]

@Apwc use the dynamic select tool

[Apwc]

Thank you! That is super helpful!