Searching range

[MN_Excel]

I'm attempting to search an entire tab for a specific name and if that name is found I would like an "X" to be displayed. Currently I'm using the following formula, but it appears that it is searching only a specific cell (rather than range) for the name. For example, I'm attepting to search the Jan11 for the name found in cell F11 and if found I would like to see an "X", if not, the cell will remain empty. I see the name I am searching for on the January tab, yet it is coming back with a blank cell, which implies the formula didn't find the text? Any ideas on how to correct?

=IF(ISNUMBER(SEARCH(F11,'Jan11'!A1:G50)),"X","")

 

[cgendron]

That formula looks correct, i just tried it to see what was wrong and it placed X's where it was suppose to so it worked correctly on my end. Perhaps the name is not spelled the same in cell F11 than it is throughout the rest of the tab? Try just doing and edit find and look for what is it F11 to make sure the spelling and format is correct