=IF(COUNTIFS(Sheet1!A$1:A$122,C2)>0,”yes”,”no”)
where sheet1 is the lookup sheet
c2 is the value to lookup
Excel check for existence of value in range
Leave a reply
=IF(COUNTIFS(Sheet1!A$1:A$122,C2)>0,”yes”,”no”)
where sheet1 is the lookup sheet
c2 is the value to lookup