Formula needed

H

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
 
J

JE McGimpsey

Harvey Waxman said:
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.
Click to expand...

One way:

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

Harvey Waxman

JE McGimpsey said:
One way:

=IF(COUNTIF(Sheet2!A1:A1000,A1),"Yes","No")
Click to expand...

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
 
Top