IF function referencing different sheet

[RomanGriffen]

What I want to do is what I thought was quite simple. LOL I want to compare the column T in sheet ALL to column T in sheet ThisWeek. In sheet ALL I would like to display the number 1 in field U if there are matches. And display nothing if there aren't. Now, keep this in mind. The entry is column T in sheet ThisWeek will appear several times in Sheet ALL. I want to have a 1 appear for every instance in sheet ALL. Doable? Please help.

[BadlySpelledBuoy]

In cell U2 on "All" try the below formula and copy down.

=IF(COUNTIF(ThisWeek!T:T,T2)>0,1,"")

Does that do what you need?

BSB.

[RomanGriffen]

I shall try it now.

[RomanGriffen]

I do believe it does, Badly. I thank you very much. This is very cool to have. Very kind of you to help.

[BadlySpelledBuoy]

Not a problem. Helping is what I'm here for.

Don't forget to mark the thread as SOLVED if you're happy you have your solution.

Take care.

BSB.