Verification Formula

  • Thread starter Thread starter ewla
  • Start date Start date
E

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
 
=IF(ISNA(VLOOKUP(B1,$A$1:$A$6,1,FALSE)),FALSE,TRUE)

Copy down

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
=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
 
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")
 
Back
Top