Hello!

Is it possible to use VLOOKUP on the concatenations of two columns as a search criteria? I would need to do this without using a helper column.

For instance if I have in one sheet the following:

A B C

3 A 10
6 A 100
9    1000
and in another sheet:

A B C

3 A
3 B
6 A
6 B
6 C
7
In the first sheet A1&B1 yields 3A. I would want to match column C from the first sheet to column C in the second sheet, considering A&B as a search criteria. The end result should be:

A B C

3 A 10
3 B
6 A 100
6 B
6 C
7
How can I achieve this without using a helper column?