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