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.
|