=IF(NOT(ISNA(MATCH(A2,M1:M100,0))),1,2)

where A2 is the date in one table, M1:m100 is the other table of dates.

Adjust to suit.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"PaulOakley" wrote
in message ...

Hello,

I am not sure how to use excel to do the following (eventually i would
like a macro to automatically perform the task).

I need to match a date from one table to another, and if the dates
match i need to insert a number into a cell. If they do not match i
also need a number to be entered into a cell but this number will be
different to if the dates do match.

Could anyone advise me on how to do this??

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