multiple lookup

[Melanie]

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

 

[trip_to_tokyo]

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]

EXCEL 2003

In first workbook, Row 4=Customer name (text), Row5=Site name(text). Rest
of column is data(numbers) for that particular Customer & Site.

My second workbook is for the user to select customer and site so that it is
organized in a friendly, readable format.

Thanks,

 

[trip_to_tokyo]

1. All right, so this is what we have:-

This is all in column A:-

A1 empty
A2 empty
A3 empty
A4 Smith (this is the customer name that you mention)
A5 New York (this is the site name that you mention)
A6 1 (rest of column is numbers - as you say)
A7 2 (rest of column is numbers - as you say)
A8 3 (rest of column is numbers - as you say)
A9 4 (rest of column is numbers - as you say)
A10 5 (rest of column is numbers - as you say)

My first thought is that you should have 2 (maybe 3) separate columns.

Column A must have only text. It seems that you should call column A
CustomerName.

Column B must have only text. It seems that you should call column B Site.

Column C must have only numbers. It seems that you should call column C
CustomerAndSite.

2. Why do you need a 2nd Workbook? What is its purpose?

3. I have just put a file up for you at:-

http://www.pierrefondes.com/

The first file at the top of the home page is for you.

It is, I think, what you have described.

So where do you want to go from here?

 

[trip_to_tokyo]

I am signing out for today (Thu Oct 1/9) at 2007 London time.

I will try and help you out again tomorrow.

You can mail me by clicking on trip_to_tokyo.