Formula to compare a cell to find same value in a column in Excel
 

I have customer data in an Excel spreadsheet with about 500 customers IDs in
one column and a list say 60 delinquent customer's IDs in another. I want a
simple formula to state whether a customer on the list is delinquent or not,
preferably to put a "1" in the column if the customer is on the delinquent
list, and a "0" if the customer is not.

Formula to compare a cell to find same value in a column in Excel
 

Try this:
For
CustomerID's in Col_A on Sheet1
Delinquent list in Col_A on Sheet2

On Sheet1,
A1: (some customerID)
B1: =--ISNUMBER(MATCH(A1,Sheet2!$A$1:$A$100,0))

Adjust ranges to suit your situation.

Does that help?

***********
Regards,
Ron


"Diane Briltz" wrote:

I have customer data in an Excel spreadsheet with about 500 customers IDs in
one column and a list say 60 delinquent customer's IDs in another. I want a
simple formula to state whether a customer on the list is delinquent or not,
preferably to put a "1" in the column if the customer is on the delinquent
list, and a "0" if the customer is not.