View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hee Chee Soon Hee Chee Soon is offline
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