Hey, Paul. We'll need to know what that number is or where it's coming from,
or the methodology deciding what it is, before we can help you get it into
that cell. Offhand, however:

=if(b2=a2,"number","other number")
*******************
~Anne Troy

www.OfficeArticles.com


"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