Vlookup with more than one condition

[nphuong84]

Hi,

I have this case:

item1	item2				item1	item2	value
A	B				A	B	1
A	C				A	C	2
A	D				A	D	3
M	B				M	B	4
M	C				M	C	5
M	D				M	D	6

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 solution]

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

[nphuong84]

Hi @RolandSchubert ,

It works, that is great. I think that I really don't understand the function of Alteryx tools, do you have any advice that where I can study the tools and apply this effectively.

Thanks

Phuong