I'm not sure if I'm trying to use the right function or if I'm just messing
it up.

I'm trying to make a different version of a sheet that I already have. I
want to make a function that will search my other sheet for a word and if
that word is on that sheet, it will put an "X" in that box of the new sheet.

So far I have =IF(B3=, "X", " ")

It works if after the = you put the exact box that the word is in, but I
can't get it to search the whole sheet for that word.


Any help would be appreciated. Thank you.