VLOOKUP for concatenation

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:

Please Login or Register  to view this content.

and in another sheet:

Please Login or Register  to view this content.

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:

Please Login or Register  to view this content.

How can I achieve this without using a helper column?

Hi!

First of all: Thank you very much! Leelnich's formula works.

@benishiryo: your formula yields only "0". Why is that?