Hi, I have no idea how to approach this problem:

One file I have all the possible data I need (by Customer and Site).
eg. Customer A, site 1. Customer A, site 2. Customer B, site1. Customer
B, site 3... etc.

The second file, I would like to select the Customer, then based on the
Customer, select the site (there may be multiple sites for each Customer).
Then populate the column with the data pulled for that particular Customer &
Site.

Any suggestions on 1) how to only pull up the respective sites to each
Customer?
2) how to do the lookup based on the two criteria?

Thanks in advance...