Hi,

Thank you in advance if anyone has time to help me with this.

I use 'vlookup' to look up a table where

-Lookup_value is a date formatted as English (United States) Type
14-Mar-01 -

and the column in the

-Table_Array is also formatted as English (United States) Type
14-Mar-01 -

I am in the UK and I get the desired results from the look up but when
my colleague in the US tries, he gets results where the month and day
seem to be transposed - even though the cells have been formatted as US
dates.

Can anyone throw any light on this please.

Thanks.


--
manse
------------------------------------------------------------------------
manse's Profile: http://www.excelforum.com/member.php...o&userid=22866
View this thread: http://www.excelforum.com/showthread...hreadid=502034