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

Ugh!

I see you're using the match_type 1 that means your data is sorted ascending
meaning that if an exact match isn't found then find the closest match. So,
would these other matches be exact matches or the closest matches?

If you're going for the closest match this will be very complicated and the
resultant formula will be very long.

Any chance I can see your file?

Biff

"ben simpson" wrote in message
...
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