If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
multiple lookup
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... |
#2
|
|||
|
|||
multiple lookup
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... |
#3
|
|||
|
|||
multiple lookup
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" wrote: 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... |
#4
|
|||
|
|||
multiple lookup
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? "Melanie" wrote: 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" wrote: 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... |
#5
|
|||
|
|||
multiple lookup
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. "trip_to_tokyo" wrote: 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? "Melanie" wrote: 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" wrote: 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... |
Thread Tools | |
Display Modes | |
|
|