I have a calendar that uses Vlookup functions to look up a persons DOB
or other date from a list and displays the persons name if their DOB or
other date coincides with the calendar date. I can't figure out how to
display more than one person in the same cell (merged cells) if they
have the same DOB or other date. I would really appreciate any help.


01/01/2006 08/05/2006 BEN
01/01/2006 08/05/2006 SAM
01/01/2006 08/05/2006 JAMES

The function will only display the person that it finds first (BEN).

Here is the formula im using

=IF(ISNA(VLOOKUP(B5,List1,3,FALSE)=TRUE),IF(ISNA(V LOOKUP(B5,list2,2,FALSE)=TRUE),"
",VLOOKUP(B5,list2,2,FALSE)),VLOOKUP(B5,List1,3,FA LSE))


--
Willco
------------------------------------------------------------------------
Willco's Profile: http://www.excelforum.com/member.php...o&userid=37592
View this thread: http://www.excelforum.com/showthread...hreadid=572170

Hi Willco,

May a Pivot table could help you a lot
hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Willco" escreveu:


I have a calendar that uses Vlookup functions to look up a persons DOB
or other date from a list and displays the persons name if their DOB or
other date coincides with the calendar date. I can't figure out how to
display more than one person in the same cell (merged cells) if they
have the same DOB or other date. I would really appreciate any help.


01/01/2006 08/05/2006 BEN
01/01/2006 08/05/2006 SAM
01/01/2006 08/05/2006 JAMES

The function will only display the person that it finds first (BEN).

Here is the formula im using

=IF(ISNA(VLOOKUP(B5,List1,3,FALSE)=TRUE),IF(ISNA(V LOOKUP(B5,list2,2,FALSE)=TRUE),"
",VLOOKUP(B5,list2,2,FALSE)),VLOOKUP(B5,List1,3,FA LSE))


--
Willco
------------------------------------------------------------------------
Willco's Profile: http://www.excelforum.com/member.php...o&userid=37592
View this thread: http://www.excelforum.com/showthread...hreadid=572170

You could use a filter instead, start with "AutoFilter", see
http://www.contextures.com/tiptech.html
http://www.datapigtechnologies.com/ExcelMain.htm
in order to use auto filer you would want to create helper columns
assuming that the date of birth is in A2
F2: =MONTH(A2)
G2: =DAY(A2)
Row 1 must have titles for the columns (column headers)
Data, Filter, Auto Filter
click on arrow on F1 and choose 8
click on arrow on G1 and chhose 5
you now have a filtered list. Note use blue on arrows denoting filtered.

To eliminate filtered results, to do a different filter
Data, Filter, Show All
Disqusted with filtering, don't need to restore the file, simply
Data, Filter, uncheck Autofilter
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Willco" wrote in message
...

I have a calendar that uses Vlookup functions to look up a persons DOB
or other date from a list and displays the persons name if their DOB or
other date coincides with the calendar date. I can't figure out how to
display more than one person in the same cell (merged cells) if they
have the same DOB or other date. I would really appreciate any help.


01/01/2006 08/05/2006 BEN
01/01/2006 08/05/2006 SAM
01/01/2006 08/05/2006 JAMES

The function will only display the person that it finds first (BEN).

Here is the formula im using

=IF(ISNA(VLOOKUP(B5,List1,3,FALSE)=TRUE),IF(ISNA(V LOOKUP(B5,list2,2,FALSE)=TRUE),"
",VLOOKUP(B5,list2,2,FALSE)),VLOOKUP(B5,List1,3,FA LSE))


--
Willco
------------------------------------------------------------------------
Willco's Profile: http://www.excelforum.com/member.php...o&userid=37592
View this thread: http://www.excelforum.com/showthread...hreadid=572170