Matching Numbers-PLEASE HELP

  • Thread starter Thread starter Paige
  • Start date Start date
P

Paige

Ok...in column A,cells 1-500, I have 500 numbers listed.
In B1, there is a number. I want to write a
function/formula that will tell me if the number in B1
matches ANY of the numbers in column A. This sounds so
simple, but yet I CANNOT figure out how to do it. Please
Help!!!!!
 
Paige,

Try a formula like the following:

=IF(ISERROR(MATCH(B1,A1:A500,0)),"No Match","Match")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Ok...in column A,cells 1-500, I have 500 numbers listed.
In B1, there is a number. I want to write a
function/formula that will tell me if the number in B1
matches ANY of the numbers in column A. This sounds so
simple, but yet I CANNOT figure out how to do it. Please
Help!!!!!
Click to expand...


=IF(COUNTIF(A1:A500,B1)>0,"match","NO match")


--ron
 
Back
Top