VLOOKUP 2 columns without CONCENATE or & possible?

[3nduranc3]

Hey All,

I would have a basic question. I have a 2 sheets that have more columns, I want to do a VLOOKUP, but based on two cells. The target table where I search has also two columns, which give the clear identification. Can I use VLOOKUP without putting an extra Concenate column or using & " " & to make an extra columns, so just with a simple function or macro?

Like this:

Table 1 Table 2

A B C A B D E F
1 2 4 1 2 .. .. VLOOKUP C according to A and B
3 2 5 3 2

Thanks!

 

[Aladin Akyurek]

Hey All,

I would have a basic question. I have a 2 sheets that have more columns, I want to do a VLOOKUP, but based on two cells. The target table where I search has also two columns, which give the clear identification. Can I use VLOOKUP without putting an extra Concenate column or using & " " & to make an extra columns, so just with a simple function or macro?

Like this:

Table 1 Table 2

A B C A B D E F
1 2 4 1 2 .. .. VLOOKUP C according to A and B
3 2 5 3 2

Thanks!

Unclear what to return...

=INDEX(ResultRange,MATCH(1,IF(Range1=LookupValue1,IF(Range2=LookupValue2,1)),0))

which needs to be confirmed with control+shift+enter, not just enter.