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. NYWICADEHI111AAAAAAAAAAAA222AAAAAA999AAAAAA333AAAAAA666888777444555AAAAAAAAAAAAAAAAAA 111Yes222No333No444Yes555No666Yes777No888Yes999No Result NYWICADEHIYesAAAAAAAAAAAANoAAAAAANoAAAAAANoAAAAAAYesYesNoYesNoAAAAAAAAAAAAAAAAAA

Vlookup/ replace multiple fields

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

Help

Accepted answers

binu_acs

@Apwc use the dynamic select tool

Trsndpodr_27032024.yxmd

All comments

binu_acs

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

Trsndpodr_27032024.yxmd

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

Replace multiple fields.yxmd

binu_acs

@Apwc use the dynamic select tool

Trsndpodr_27032024.yxmd

Apwc

Thank you! That is super helpful!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703