MAXA won't work with VLOOKUP?

[amirstal]

Using vlookup, A1 returns 09/18/2008 while B1 returns 09/17/2008. When
I apply C1=MAXA(A1,B1) I am getting zero instead of 09/18/2008. Doing
the same thing to A1 and B1 but not using vlookup returns the correct
value (09/16/2008). Is there a way to make MAXA work with vlookup?

Thanks,

Amir

 

[Mike H]

Hi,

MAXA works ok with vlookup provided the values returned are numeric which
dates are.

I suggest you try this on both a1 and b1

=isnumber(a1)
=isnumber(b1)

If they return FALSE then your dates aren't really dates and your problem
lies in the data your vlookup is returning.

Mike