Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup across multiple columns within multiple sheets | Excel Discussion (Misc queries) | |||
Multiple lookup values and adding multiple rates across together | Excel Worksheet Functions | |||
Lookup using multiple sheets and multiple criteria, sorry if 2 pos | Excel Worksheet Functions | |||
Lookup using multiple sheets and multiple criteria | Excel Discussion (Misc queries) | |||
Lookup in Multiple Columns, Return Multiple Values | Excel Worksheet Functions |