Using IF with a list

B

Benoit

Hello,

My question, for me, is complicated so I'll try to give
as many details as possible.

In the "A" colum, I have diggerent numbers:

A1: 604551
A2: 604552
A3: 604553
A4: 604554
A5: 604555

In the B colum, I wanna use the "IF" feature. I would
have a list of numbers in the "E" colum and I want
the "IF" feature to put a "1" in the "B" colum if it
matchs a number from the predefined list.

The only little problem, teh list has about 500 numbers.

If you think you can help me but you need more details or
a file to give you an example of what I would like to do,
please e-mail me!!!

Thanks!!!
 
B

Benoit

Thanks!!!

However, is it possible to use VLOOKUP to have a "1" put
in the "B" colum when the number inserted in colum "A"
corresponds to a number in the list and to have a "0"
when it's not???

Thanks!!!
 
A

Anders S

Benoit,

Try this,

=IF(ISNA(VLOOKUP(A1,$E$1:$E$22,1,FALSE))=FALSE,1,0)

Enter in B1 and fill down.


HTH
Anders Silven
 
B

Bob Phillips

Hi Benoit,

B1: =IF(NOT(ISNA(VLOOKUP(A1,$E$1:$E$500,1,FALSE))),1,"")

and copy down

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
F

Frank Kabel

Hi Bob
I would simplify this (one function call less) to
B1: =IF(ISNA(VLOOKUP(A1,$E$1:$E$500,1,FALSE)),"",1)
 
Top