Just another play to try ..

Assume all the 1000+ possible values are listed in say, Sheet2's col A

Then in Sheet1,
Put in A1:
=IF(ISNUMBER(MATCH(B1,Sheet2!A:A,0)),"*","")
Copy A1 down to return correspondingly
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"gimp" wrote:
.. i probably have 1000 or more possibilities.

.. i was given the formula to use in cell A1 if cell b1 = x to make A1
either be blank if it said something other than x, or if it said x it
would generate an (*). now is there a formula that can be used in the
same senario if B1 had a series of possible values to generate a (*) in
cell A1?