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?
Bookmarks