Forget about that one, not correct.
Sorry

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Niek Otten" <nicolaus@xs4all.nl> wrote in message news:%23ZtXs4VwGHA.1304@TK2MSFTNGP06.phx.gbl...
| <#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" <samprince.2cn8st_1155750008.8256@excelforum-nospam.com> wrote in message
| news:samprince.2cn8st_1155750008.8256@excelforum-nospam.com...
||
|| 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
||
|
|