LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Vlookup for a minimum value

Dear All,

I really face a problem here, can somebody help me?

A B C
Member's Code Introducer Name Date Join
123456 Jessica 1/4/2009
123457 May 3/5/2009
123458 Albert 3/5/2009
123459 Jessica 4/5/2009
123461 Steven 3/5/2009
123451 Jessica 5/4/2009
123586 May 6/5/2009
.... ... ...

At another worksheet, I need to use vlookup function to search any
introducer to find which is their 1st member with smallest date join without
going back to do sorting at my database. (What i need is their Date join
only... )

Do you have any idea to solve this problem?

Thank you very much.!!!!

Regards,
Hee Chee Soon
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Minimum IF Jive Excel Worksheet Functions 4 March 3rd 08 05:42 PM
Minimum Value Alex Excel Worksheet Functions 2 August 1st 07 03:44 PM
How to lookup the minimum, 2nd minimum and 3rd minimum......... Mark McDonough Excel Worksheet Functions 8 July 15th 06 09:39 PM
minimum ridash Excel Worksheet Functions 4 June 23rd 06 03:00 PM
Minimum but One?? twogoodtwo Excel Worksheet Functions 3 November 29th 05 02:52 PM


All times are GMT +1. The time now is 05:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"