Equivalent of VLookup?

Question

Hi,

I want to be able to use a formula (or whatever tool) that could do the equivalent of a Vlookup. I'm not very experienced so I'd love all the help I could get.

I created some sample data to show you what I mean. Is it possible to use a formula that uses the condtions [commodity]=[c type] and [StartDate]=[month] to specifically grab the closing price that corresponds? I think creating a formula with a new column would help and thus allow for me to do what I need.

This is what I'm attempting.

Thanks,

derm

Capture.PNG

cjaneczko · Accepted Answer

Is your data on two different inputs. Typically the Join Tool would act as the equivalent of VLOOKUP in excel.

JosephSerpis · Accepted Answer

Hi @derm have a look at this Alteryx & Excel Guide on the Alteryx community and specifically this post on How to do a VLOOKUP in Alteryx.