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