Worksheet function with range reference

[Marie]

Hi,

I have a range of cells (R6:R100) that contains distinct
two-letter codes. I am trying to enter a function that
states something like:

If the value of cell C6 matches one of the cells listed in
the range (R6:100), display "yes" in cell H6. Otherwise,
display "no" in cell H6.

Thanks in advance, Marie

 

[Felipe]

Marie,

In cell H6 type:

=IF(countif(R1:R100,C6),"yes","no")

Regards,
Felipe

 

[Dan E]

A few options:

=IF(SUMPRODUCT((R6:R100=C6)*1)>0, "Yes", "No")

=IF(ISERROR(MATCH(C6,R6:R100,0)),"No","Yes")

=IF(ISERROR(VLOOKUP(C6,R6:R100,1,FALSE)),"No","Yes")

Dan E

 

[Marie]

Just what I was looking for. Thank you

-----Original Message-----
Marie,

In cell H6 type:

=IF(countif(R1:R100,C6),"yes","no")

Regards,
Felipe

.