COUNTIF function does this for you.

=IF(COUNTIF(range,valuetolookup)0,1,0)



--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Michael" wrote:

I would like to look-up a cell's value in a range of cells and return 1 if it
exists or zero if it does not exist in the specified range. I have got to
believe this is a fairly common need. Can anyone help me out with this.