S
soconfused
I have one worksheet with two sheets. On the first sheet I have a list in
column Q. I want to check that row against column A in the second sheet. If
I find and exact match, I want to put "Checked" in column AA, if not I want
it to be blank. This is the formula that I've tried:
IF(COUNTIF('Prior Month'!$A$1:$A$100,Q5)>"","Checked","")
column Q. I want to check that row against column A in the second sheet. If
I find and exact match, I want to put "Checked" in column AA, if not I want
it to be blank. This is the formula that I've tried:
IF(COUNTIF('Prior Month'!$A$1:$A$100,Q5)>"","Checked","")