How to check the value?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eric - 24 Mar 2008 04:24 GMT

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

Reply to this Message

Max - 24 Mar 2008 04:42 GMT

In C1, copied down: =IF(B1="","",ISNUMBER(MATCH(B1,A:A,0)))

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Does anyone have any suggestions on how to check the value from a list of
> numbers?
[quoted text clipped - 4 lines]
> Thanks in advance for any suggestions
> Eric

Reply to this Message

Rick Rothstein (MVP - VB) - 24 Mar 2008 10:17 GMT

Give this a try...

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

Rick

> Does anyone have any suggestions on how to check the value from a list of
> numbers?
[quoted text clipped - 7 lines]
> Thanks in advance for any suggestions
> Eric

Reply to this Message