How to check the value?
 

Does anyone have any suggestions on how to check the value from a list of
numbers?
For example, there is a list of number under A column, and there is a given
number in cell B1. If I find any number under A column, which match the given
number in cell B1, then return True in cell C1, else return False in cell C1.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

How to check the value?
 

In C1, copied down: =IF(B1="","",ISNUMBER(MATCH(B1,A:A,0)))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Eric" wrote:
Does anyone have any suggestions on how to check the value from a list of
numbers?
For example, there is a list of number under A column, and there is a given
number in cell B1. If I find any number under A column, which match the given
number in cell B1, then return True in cell C1, else return False in cell C1.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

How to check the value?
 

Give this a try...

=ISNUMBER(MATCH(B1,A:A,0))

Rick


"Eric" wrote in message
...
Does anyone have any suggestions on how to check the value from a list of
numbers?
For example, there is a list of number under A column, and there is a
given
number in cell B1. If I find any number under A column, which match the
given
number in cell B1, then return True in cell C1, else return False in cell
C1.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric