Hi Manse,

You don't format as UK or USA, you format as "dd-mmm-yyyy" or "dd-mm-yy" or
whatever.
But this is just formatting; the underlying value is what is used in the
VLOOPKUP (normally, but unfortunately you didn't give us your formula); that
is always the number of days since 1-1-1900 (roughly).
So the VLOOKUP should work.
There used to be an issue with formatting dates in older versions of Excel,
I don't know about recent versions: if the formatting happened to be the
standard date for your system, Excel just remembered "Standard date" and so
on the other system used the Standard date of *that* system, no matter what
you originally specified. But again, the VLOOKUP should work, UNLESS there
is a TIME part involved, which may be present, but not show.
What is the formula of your VLOOKUP? What are the input values? What if you
format them as General? What result did you expect and what did you get
instead?


--
Kind regards,

Niek Otten

"manse" wrote in
message ...

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