lookup

[LH]

I need to look up one number at a time in a separate
range of numbers. I tried an IF statement but the format:

if(b2=c2:c50)"yes", "no"

This format didn't work. I even tried naming the range.
Can anyone help?

 

[Jason Morin]

=IF(SUMPRODUCT(--(B2=C2:C50))>0,"yes","no")

HTH
Jason
Atlanta, GA

 

[Don Guillett]

how about
=IF(COUNTIF(A1:A10,D5)>0,1,2)