software

I'm using the formula:
=IF(MATCH(C51,'Data Sheet'!A4:A103,1),quot;Added Holiday(s) For:quot;,quot;quot;)

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

Hi!

Try this:

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

Biff

quot;ben simpsonquot; gt; wrote in message
...
gt; I'm using the formula:
gt; =IF(MATCH(C51,'Data Sheet'!A4:A103,1),quot;Added Holiday(s) For:quot;,quot;quot;)
gt;
gt; What I'm wanting to do is to add the information from 'Data Sheet'!B4:B103
gt; to print out after the quot;Addedquot; statement (the actual name of the holiday
gt; listed). What would be the best way to accomplish this?....Thanks....Ben
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
quot;Biffquot; wrote:

gt; Hi!
gt;
gt; Try this:
gt;
gt; =IF(ISNA(MATCH(C51,'Data Sheet'!A4:A103,1)),quot;quot;,quot;Added Holiday(s) For:
gt; quot;amp;VLOOKUP(C51,'Data Sheet'!A4:B103,2))
gt;
gt; Biff
gt;
gt; quot;ben simpsonquot; gt; wrote in message
gt; ...
gt; gt; I'm using the formula:
gt; gt; =IF(MATCH(C51,'Data Sheet'!A4:A103,1),quot;Added Holiday(s) For:quot;,quot;quot;)
gt; gt;
gt; gt; What I'm wanting to do is to add the information from 'Data Sheet'!B4:B103
gt; gt; to print out after the quot;Addedquot; statement (the actual name of the holiday
gt; gt; listed). What would be the best way to accomplish this?....Thanks....Ben
gt;
gt;
gt;

gt; Hi there. Thanks for looking in. I tried the formula and realized that
gt; there might be as many as 4 matches. This only listed the last match.
gt; How
gt; 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

quot;ben simpsonquot; gt; wrote in message
...
gt; Hi there. Thanks for looking in. I tried the formula and realized that
gt; there might be as many as 4 matches. This only listed the last match.
gt; How
gt; can i make it list all of them?.....Ben
gt;
gt;
gt;
gt; quot;Biffquot; wrote:
gt;
gt;gt; Hi!
gt;gt;
gt;gt; Try this:
gt;gt;
gt;gt; =IF(ISNA(MATCH(C51,'Data Sheet'!A4:A103,1)),quot;quot;,quot;Added Holiday(s) For:
gt;gt; quot;amp;VLOOKUP(C51,'Data Sheet'!A4:B103,2))
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;ben simpsonquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; I'm using the formula:
gt;gt; gt; =IF(MATCH(C51,'Data Sheet'!A4:A103,1),quot;Added Holiday(s) For:quot;,quot;quot;)
gt;gt; gt;
gt;gt; gt; What I'm wanting to do is to add the information from 'Data
gt;gt; gt; Sheet'!B4:B103
gt;gt; gt; to print out after the quot;Addedquot; statement (the actual name of the
gt;gt; gt; holiday
gt;gt; gt; listed). What would be the best way to accomplish
gt;gt; gt; this?....Thanks....Ben
gt;gt;
gt;gt;
gt;gt;
Well...oops...its supposed to be a 0 match. It will be an exact match. I'm
matching a list of dates (holidays that I've looked up manually) against
todays date when it falls within a work cycle. The message needs to remain
there thru the end of the cycle (which I can easily reference).

I broke it down into 2 parts (Keeping the quot;Addedquot; statement seperate, in in
the preceeding cell).

It now looks like this:
In A28
=IF(ISNA(MATCH(F51:AF52,'Data Sheet'!A4:A103,0)),quot;quot;,quot;Added Holiday(s) For:quot;)

In C28
=IF(ISNA(MATCH(F51:AF52,'Data Sheet'!A4:A103,0)),quot;quot;,VLOOKUP(C51,'Data
Sheet'!A4:B103,0))The F51:AF52 is the range of dates that I need to compare the list against.
All of this of course lists only the last match it finds, while needing all
the matches it finds listed.

Unfortuneately I can't send it for you to look at. I'm locked out, and
can't get permission to do so.

Thanks again.....Benquot;Biffquot; wrote:

gt; gt; Hi there. Thanks for looking in. I tried the formula and realized that
gt; gt; there might be as many as 4 matches. This only listed the last match.
gt; gt; How
gt; gt; can i make it list all of them?.....Ben
gt;
gt; Ugh!
gt;
gt; I see you're using the match_type 1 that means your data is sorted ascending
gt; meaning that if an exact match isn't found then find the closest match. So,
gt; would these other matches be exact matches or the closest matches?
gt;
gt; If you're going for the closest match this will be very complicated and the
gt; resultant formula will be very long.
gt;
gt; Any chance I can see your file?
gt;
gt; Biff
gt;
gt; quot;ben simpsonquot; gt; wrote in message
gt; ...
gt; gt; Hi there. Thanks for looking in. I tried the formula and realized that
gt; gt; there might be as many as 4 matches. This only listed the last match.
gt; gt; How
gt; gt; can i make it list all of them?.....Ben
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Biffquot; wrote:
gt; gt;
gt; gt;gt; Hi!
gt; gt;gt;
gt; gt;gt; Try this:
gt; gt;gt;
gt; gt;gt; =IF(ISNA(MATCH(C51,'Data Sheet'!A4:A103,1)),quot;quot;,quot;Added Holiday(s) For:
gt; gt;gt; quot;amp;VLOOKUP(C51,'Data Sheet'!A4:B103,2))
gt; gt;gt;
gt; gt;gt; Biff
gt; gt;gt;
gt; gt;gt; quot;ben simpsonquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; I'm using the formula:
gt; gt;gt; gt; =IF(MATCH(C51,'Data Sheet'!A4:A103,1),quot;Added Holiday(s) For:quot;,quot;quot;)
gt; gt;gt; gt;
gt; gt;gt; gt; What I'm wanting to do is to add the information from 'Data
gt; gt;gt; gt; Sheet'!B4:B103
gt; gt;gt; gt; to print out after the quot;Addedquot; statement (the actual name of the
gt; gt;gt; gt; holiday
gt; gt;gt; gt; listed). What would be the best way to accomplish
gt; gt;gt; gt; this?....Thanks....Ben
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;