This is my formula =IF(COUNTIF(B$6:B$21,"*"&$A6&"*"),"","Free"). Instead of showing nothing if CountIf returns 1, I'd like to show the value of the cell. Because it is a range, I'm not sure how to show just the value of the cell where it matches my condition. Kindly advise. Thanks a lot!