Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 20th 12, 05:29 PM
Junior Member
 
First recorded activity by ExcelBanter: Aug 2012
Posts: 2
Question 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   Report Post  
Old September 21st 12, 03:03 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,727
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


Reply
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
Searching specific record using VLOOKUP function. dev Excel Worksheet Functions 12 July 4th 08 11:51 PM
Value searching in columns - vlookup can not do it? Barney W Excel Discussion (Misc queries) 4 November 18th 07 07:32 PM
VLookup Not Searching the entire cell for Match LAP Excel Discussion (Misc queries) 3 February 23rd 07 05:40 PM
VLOOKUP always required the searching field SORTED? Johan2000 Excel Programming 1 November 9th 06 12:55 PM
searching for vlookup equivalent in VBA Tom Ogilvy Excel Programming 0 August 31st 04 06:20 PM


All times are GMT +1. The time now is 10:28 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017