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