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.
Bookmarks