Formula needed

[Harvey Waxman]

In cell N1 of sheet #1,

If the value in A1 is found anywhere in column (A1:a1000) in sheet #2, put
"yes" in N1 of sheet #1

Should be easy but I'm having trouble with it.

--
Harvey Products makers of Dinghy Dogs
The Boater's Best Friend
http://www.dinghydogs.com
Ladies' handbags and accessories
http://www.deducktibles.com
Remove thefrown to email me

 

[JE McGimpsey]

In cell N1 of sheet #1,

If the value in A1 is found anywhere in column (A1:a1000) in sheet #2, put
"yes" in N1 of sheet #1

Should be easy but I'm having trouble with it.

One way:

=IF(COUNTIF(Sheet2!A1:A1000,A1),"Yes","No")

 

[Harvey Waxman]

One way:

=IF(COUNTIF(Sheet2!A1:A1000,A1),"Yes","No")

Of course! why do I try to make things so hard?

Since the column in sheet two is constant A1 should be $A$1 etc?

And would there be a difference if it were array entered and copied down the
list.

And thank you yet again.


--
Harvey Products makers of Dinghy Dogs
The Boater's Best Friend
http://www.dinghydogs.com
Ladies' handbags and accessories
http://www.deducktibles.com
Remove thefrown to email me