View Single Post
  #2   Report Post  
Old September 21st 12, 03:03 PM posted to microsoft.public.excel.newusers
Claus Busch Claus Busch is offline
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,739
Default Searching another entry with vlookup

Hi,

Am Thu, 20 Sep 2012 16:29:36 +0000 schrieb Abhijit Rana:

I have names and date of birth on a excel sheet. I want to see on
another sheet the names of people who have birthday today. Is this
possible by vlookup or any other way? The problem I am facing is if I
put vlookup by date or names it gives me name of only one person in case
of multiple people are on same day.


try the advanced filter


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2