topic Re: Simple VLookup for a created column in Alteryx Designer Desktop Discussions

Simple VLookup for a created column

Christian1998 — Mon, 25 Sep 2023 14:57:10 GMT

Hello,

Is there a way to add a VLOOKUP that should appear in a new column? Specifically about invoice numbers from 2 different sheets. Thanks in advance.

Regards

Re: Simple VLookup for a created column

Prometheus — Mon, 25 Sep 2023 15:01:58 GMT

@Christian1998 You can either use a Join tool to bring the two data sources together and deselect the field you don't want to keep, or you can use the Find Replace tool. Just know that with the Find Replace tool, it'll only find and replace string values.