Question about functions
Ah, I was using the wrong function. Thank you. I took that and modified it a
bit obviously (actual name of the sheet to search and "hello" to B3). Worked
perfect. Now if there was only a way to put that function in every box and
not have to type the cell to match to each time. IE B3, C3, D3.
Thanks
"Martin Fishlock" wrote:
Hi Spam N:
Try using the countif function.
=if(COUNTIF(Sheet2!$1:$65536,"hello")0,"X","")
You need to change the last row if you are working in the lastest version of
excel.
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.
"Spamn" wrote:
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.
|