Hi Jim

I'm sorry, I misread your post. I thought you were wanting to do a
comparison cell by cell as you copied the formula down the column.

To do what you want,
=IF(COUNTIF(Sheet2!A:A,"="&A1)0,"YES","NO")

Regards

Roger Govier


jim314 wrote:
Actually, I'm trying to see if the value in Sheet1 is _anywhere_ in column A
of Sheet2, not just in A1 of Sheet2.

Thanks, though.

"Roger Govier" wrote:


Hi

Try
=IF(Sheet2!A1=A1,"YES","NO")

Regards

Roger Govier


jim314 wrote:

I'm trying to determine if a date in Sheet1 is in a list of dates in Sheet2
(returning a simple, "YES" or "NO").

Example:
Sheet1:

A1 contains the following date: 09/01/05
B1 should contain the "YES" or "NO"

Sheet2:
Column A contains a list of dates, such as the following:
01/01/05
02/14/05
09/01/05
12/25/05
12/31/05

What is the best way to return a "YES" or "NO"? I have tried unsuccessfully
to do this with an if/then, but I'm thinking there must be a better way.

Thanks,

Jim