Hey @samsandy, the way to do Vlookups in Alteryx is usually with a Join (though Find & Replace is a viable option, too). Here you can see I have 2 tables - Names & Amounts. I conduct the join based on the unique identifying field, in my case [ID] and the matching records will come out of the middle (J) anchor of the Join tool:
![DataNath_0-1666082738048.png DataNath_0-1666082738048.png](https://community.alteryx.com/t5/image/serverpage/image-id/263236iA161821F743BAB30/image-size/medium?v=v2&px=400)
![DataNath_1-1666082745508.png DataNath_1-1666082745508.png](https://community.alteryx.com/t5/image/serverpage/image-id/263237i106B0127E7CDCEAE/image-size/medium?v=v2&px=400)
![DataNath_2-1666082752923.png DataNath_2-1666082752923.png](https://community.alteryx.com/t5/image/serverpage/image-id/263238i5E9183C6327AE105/image-size/medium?v=v2&px=400)
Hope this helps but let us know if not - workflow attached for you to check out.
Edit: In case you were curious, the Find & Replace method looks something like this, whereby you search for matches of the second table within the first, and append the extra field (Sales in my example) when a match is found:
![DataNath_0-1666082990942.png DataNath_0-1666082990942.png](https://community.alteryx.com/t5/image/serverpage/image-id/263239i9332DCE9C30FFA70/image-size/medium?v=v2&px=400)