| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Searching another entry with vlookup
Hi,
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. Regards, Abhijit Last edited by Abhijit Rana : September 20th 12 at 07:27 PM |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Searching specific record using VLOOKUP function. | Excel Worksheet Functions | |||
| Value searching in columns - vlookup can not do it? | Excel Discussion (Misc queries) | |||
| VLookup Not Searching the entire cell for Match | Excel Discussion (Misc queries) | |||
| VLOOKUP always required the searching field SORTED? | Excel Programming | |||
| searching for vlookup equivalent in VBA | Excel Programming | |||
Linear Mode
