Melanie, some quick questions:-

1. What version of EXCEL are you in.

Are you in 2007?

2. What are your column names?

Are they:-

Column A = customer

Column B = site

3. What is in column A?

Is it text (for customer names)?

4. What is in column B?

Is it numbers (for sites).

5. What do your mean by, €œthe second file€�?

Do you mean a 2nd Worksheet in the same Workbook?

This info will help me / others to help you.



"Melanie" wrote:

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