Vlookup with more than one condition

Question

Hi,

I have this case:

item1item2   item1item2valueAB   AB1AC   AC2AD   AD3MB   MB4MC   MC5MD   MD6

How can I vlookup value for A if item 2 is B so I have the result 1, if item 2 is C the result is 3, item 2 is D the result is 3 and similar for M. What is the tool that I can apply in Alteryx?

Thanks

Phuong

RolandSchubert · Accepted Answer

Hi @nphuong84 ,

you could use the JOIN tool. You can select multiple fields to join on, so you would select [item1] and [item2] for both inputs.

Hope this is helpful.

Best,

Roland