Hello guys, I hope you can help me:

In spreadsheet 1 I have a fix list of different status:

Paid
Unpaid
Collections
Delinquent

In Spreadsheet 2 I have the customers names.

I want to be able to qualify the customers on Spreadsheet 2 by selecting from a dropping down list based on Spreadsheet 1 list information.


Thanks in Advance!
Lorena