=if(isnumber(Match(A1,Sheet1!$A$1:$A$500,0)),12.5, 0)
--
Regards,
Tom Ogilvy
"PaulOakley" wrote
in message ...
Hey,
Thanks for your relpies, they are really appreciated, my first message
is a bit unclear.
I need one table which has w\commencing dates in it to check these
dates with another table, if the w\c date is matched with a date in the
other table then i need it to return the value 12.5, if it is not then
the value 0 needs to be returned.
Some background which may help is that the system i am building is
taking into account the second sunday of every month, where 12.5 hours
of cleaning is required (this will be placed in a cell and then
deducted from the total hours of operations). I have built a seperate
table in another sheet with the w\c date of the second sunday of every
month. My problem is that many of the week commencing dates that I am
checking are not present in the new sheet.
I hope this helps clarify my problem a bit more,
Thankyou in advance.
--
PaulOakley
------------------------------------------------------------------------
PaulOakley's Profile:
http://www.excelforum.com/member.php...o&userid=25103
View this thread: http://www.excelforum.com/showthread...hreadid=386726