I'm sure this can be done

[Hervinder]

Is it possible to lookup a value in a range that is not
sorted and return any return true or false if found.

 

[Vasant Nanavati]

Hi:

=NOT(ISERROR(MATCH("a",A:A,0)))

where "a" is your lookup value.

Regards,

Vasant.

 

[Peo Sjoblom]

=ISNUMBER(MATCH(A1,B1:B50,0))