Hi there. Thanks for looking in. I tried the formula and realized that
there might be as many as 4 matches. This only listed the last match. How
can i make it list all of them?.....Ben



"Biff" wrote:

Hi!

Try this:

=IF(ISNA(MATCH(C51,'Data Sheet'!A4:A103,1)),"","Added Holiday(s) For:
"&VLOOKUP(C51,'Data Sheet'!A4:B103,2))

Biff

"ben simpson" wrote in message
...
I'm using the formula:
=IF(MATCH(C51,'Data Sheet'!A4:A103,1),"Added Holiday(s) For:","")

What I'm wanting to do is to add the information from 'Data Sheet'!B4:B103
to print out after the "Added" statement (the actual name of the holiday
listed). What would be the best way to accomplish this?....Thanks....Ben