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


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

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