Verification Formula

[ewla]

Can anyone provide a formula to figure the following?

Column 1 has a list of phone numbers
Column 2 has another list of phone numbers

What I would like is for column three (C1) to compare B1 with A1:A86.
If C1 is the same as any phone number in the range, then it woul
state: TRUE. If it does not match any number, it would state:
FALSE.

This formula would then be copied down all of the third column t
perform the same function with each line

 

[Niek Otten]

=IF(ISNA(VLOOKUP(B1,$A$1:$A$6,1,FALSE)),FALSE,TRUE)

Copy down

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Jason Morin]

=IF(COUNTIF($A$1:$A$86,B1),TRUE,FALSE)

or simply

=COUNTIF($A$1:$A$86,B1),

which'll give you the 1/0 equivalent to TRUE/FALSE.

HTH
Jason
Atlanta, GA

 

[Flamikey]

=IF(VLOOKUP(B1,$A$1:$B$100,2,FALSE),"TRUE","FALSE")

 

[Flamikey]

I'm sorry, Nick is right. there needs to be an error statement in
there. I wouyld use this:

=IF(ISERROR(VLOOKUP(B1,$A$1:$B$100,2,FALSE)),"FALSE","TRUE")

 

[ewla]

Thanks. You guys are great.