Search another worksheet to find a value

[amxtomzo]

hello and thanks for helping
Id like to put a formula in Cell E4 of worksheet 2 that shows an "X" if it finds what it is looking for,
or stay blank if not found

worksheet 2 cell A4 has a value
Worksheet 1 range c11:c37 may have 1 matching value in that range

if it is found, I would like cell E4 on worksheet 2 to display an "X"

I started with this in cell E4 and think I missed it by a mile

=IF(COUNTIF(rng,Meriden06450!C11:C37,a4),"X","")

thanks

Thomas

 

[AlphaFrog]

You're close. Delete the red part.

=IF(COUNTIF(rng,Meriden06450!C11:C37,a4),"X","")

 

[amxtomzo]

AlphaFrog
thank you again
once again you cleaned up my brain fog
very much appreciated, thank you

Thomas