Q: find matching number

L

Lars Mortensen

I want to compare a number from a cell to numbers within an area and see if
it exists anywhere there.
Lets' say cell B3 comtains the number 298 and I want to know whether this
number exists in the area A1:A6.
How do I do that?
Thx in advance!
Lars
 
N

Niek Otten

Hi Lars,

=IF(ISNA(VLOOKUP(B3,A1:A6,1,FALSE)),"NO","YES")

--
Kind regards,

Niek Otten

|I want to compare a number from a cell to numbers within an area and see if
| it exists anywhere there.
| Lets' say cell B3 comtains the number 298 and I want to know whether this
| number exists in the area A1:A6.
| How do I do that?
| Thx in advance!
| Lars
|
|
 
R

Ron Coderre

Try something like this:

B3: =(COUNTIF(A1:A6,298)>0)

Does that help?
***********
Regards,
Ron

XL2002, WinXP-Pro
 
Top