vlookup with multiple criteria

[PGD15]

Hi,

Got a question i'm trying to write a vlookup with multiple criteria.

I've writen.

=Vlookup(G1&D4,'daily breakdown'!a2:av154,30,false)

But i keep getting an error message.

what am i doing wrong?

 

[kpasa]

Your basic formula is

=VLOOKUP(val1&val2,data,col_index,0)

You got that part right.

Vlookup can only do 1 lookup criteria, so we need to concatenate the two criterion into one lookup. That means you'll have to also have the first column in the lookup data table be a concatenated string as well, containing both pieces we are looking up. Otherwise it will not match.

 

[PGD15]

by concatenated you mean such as

Value1 Value 2
or
Value1Value2?

edit:

I did manage to get the formula to return 1 value correctly... my way just got an error for all the other values :'( so i thought this would be possible

 

[kpasa]

by concatenated you mean such as

Value1 Value 2
or
Value1Value2?

Value1Value2

Take a look here for a detailed explanation: https://exceljet.net/formula/vlookup-with-multiple-critiera

 

[PGD15]

Value1Value2

Take a look here for a detailed explanation: https://exceljet.net/formula/vlookup-with-multiple-critiera

=vlookup(val1&val2,data,col_index,0) in regards to this formula how do you make it return the last value instead of first, i thought that was a 1 or -1 at the end instead of a zero but tried both and nothing works just return me a 0 -_-