I am working on an If statement that shows a "yes" or "no" depending if
it is <= or = to one percent. This is what I have and it works fine.


=IF('Funding'!$G3<=1%,"yes",IF('Funding'!$G3=1%," no!"))

The problem is that column G is just the range of numbers, and it must
reference another column that has a list. For example, "45-019" would
be in the current worksheet as one instance(d3) but this number can be
repeated again say in cell D8. Another worksheet has all of the list
of numbers in column A that will be used.
Is it even possible to include the list from the other worksheet for
each instance on the worksheet with the formulas and still keep the
above statement? If so, can someone please help?


--
NeedHelp321
------------------------------------------------------------------------
NeedHelp321's Profile: http://www.excelforum.com/member.php...o&userid=24691
View this thread: http://www.excelforum.com/showthread...hreadid=382618