I don't understand why vlookup is returning 0

[Danoz]

Hi

Using excel 2007

My formula is this: "=IF(I3="","",IF(ISERROR(MATCH(I3&L3,Lists!S:S,0)),"",VLOOKUP(I3&L3,Lists!S:T,2,FALSE)))"

Column S in Lists is formatted as general, column T is date. The format of the output (formula) cell is date. I3 is formatted as general, L3 date.

Let's say I3 is Danoz and L3 is 30/6/16, the formula looks up Danoz42551 in lists!S:S. Danoz42551 exists in the range, and the corresponding value in Lists!T:T is 1/7/16, so the value returned should be 42552. But wherever I put the formula, the value returned is zero, "0", or 0/01/1900.

I've tried adding concatenate where relevant, but nothing works.

Stripping it back to just the vlookup, it still returns 0.

What's really getting to me is that when I trace it through evaluate, the return value is 42552 until the final step, when it magically becomes 0.

I don't understand why, can anyone help me?

Thanks, Danoz.

 

[Danoz]

I'm still really confused about what was happening, but moved the data set to columns D:E in Lists and the formulae began working.

This thread can be closed/removed.