Vlookup. Match. Lookup. Wtf?

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.

<#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
|

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
||
|
|