Search multiple rows and colums and return with

All,

I have been searching for days. I am in need of some assistance. I am trying to search a speadsheet on one tab, then if it finds what I want it to, I would like it to equal something else on the next tab. For example:

Search Sheet one from C4 to J19 for the number 6

If it finds the number 6, than I want it to equal "X"

I found the below fomula but I can not get it to work when i want it to search multiple from C4-J19

=IF(ISNUMBER(SEARCH("6",'Draft Board'!C4)),"X","")

Any help out there???

Thank you

...earch Sheet one from C4 to J19 for the number 6

Perhaps..

=IF(COUNTIF(Sheet1!C4:J19,6),"x","")

You are welcome and thanks for the feed back.

As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thank you.