I am trying to lookup the value in cell A2 in column H and return a Yes if that value is in Column H and a No if it is not. I have tried using the below formulas, but it keeps returning “No” on values I can clearly see are in Column H. I have tried to change the formatting of both columns, but still no luck.

=IF(COUNTIF(H:H,A2)>0,”Yes”,”No”)

=IF(ISNUMBER(MATCH(A2,H:H,0)),”Yes”,”No”)

​I am trying to lookup the value in cell A2 in column H and return a Yes if that value is in Column H and a No if it is not. I have tried using the below formulas, but it keeps returning “No” on values I can clearly see are in Column H. I have tried to change the formatting of both columns, but still no luck. =IF(COUNTIF(H:H,A2)>0,”Yes”,”No”)=IF(ISNUMBER(MATCH(A2,H:H,0)),”Yes”,”No”)  Read More

​