<#2, data is sorted in date order then user ID

Then the 4th argument of your VLOOKUP should be FALSE instead of omitted (which defaults to TRUE)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"samprince" wrote in message
...
|
| DO not understand
|
| #1, I'm looking trying to match text with text and return the date that
| corresponds in the next colum. All are correctly formatted
|
| #2, data is sorted in date order then user ID.
|
| #3, there are no spaces in the user ID's
|
| #4 & #5 I dont have a forumula yet, what i gace is my assumption of how
| it should work but does not.
|
|
| --
| samprince
| ------------------------------------------------------------------------
| samprince's Profile: http://www.excelforum.com/member.php...o&userid=34168
| View this thread: http://www.excelforum.com/showthread...hreadid=572290
|