| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to generate data from a list on excel from another worksheet?
hi, i'm stuck.
I'm trying generate a data from a list on excel. Basically I have a table on one worksheet and I have a list on another selecting the first value in each row. This bit works fine. What I am trying to do is generate the rest of the data on that row for the thing I select from the list. Please Help!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to generate data from a list on excel from another worksheet?
Hi Carole
I think you need VLOOKUP. say you have the following table named SalesTeam in A1:B5 Ref Sales Person Jne Jane Willoughby Jon John Slazinger Ptr Peter Atherton Tom Tomas Radzinski If you type jne (the value to look up) in say d2 and =VLOOKUP(D2,SalesTeam,2,0) in E2. E2 will return Jane Willoughby. Change the 2 to 3 in F2 to add another column to return and so on. The table must be sorted on the ref column for LOOKUP to work correctly. If the lookup value is not in the table Excel returns #N/A Regards Peter "carole" wrote: hi, i'm stuck. I'm trying generate a data from a list on excel. Basically I have a table on one worksheet and I have a list on another selecting the first value in each row. This bit works fine. What I am trying to do is generate the rest of the data on that row for the thing I select from the list. Please Help!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to generate data from a list on excel from another workshe
I tried what you said and it works now.
Thank you very much. Carole x "Billy Liddel" wrote: Hi Carole I think you need VLOOKUP. say you have the following table named SalesTeam in A1:B5 Ref Sales Person Jne Jane Willoughby Jon John Slazinger Ptr Peter Atherton Tom Tomas Radzinski If you type jne (the value to look up) in say d2 and =VLOOKUP(D2,SalesTeam,2,0) in E2. E2 will return Jane Willoughby. Change the 2 to 3 in F2 to add another column to return and so on. The table must be sorted on the ref column for LOOKUP to work correctly. If the lookup value is not in the table Excel returns #N/A Regards Peter "carole" wrote: hi, i'm stuck. I'm trying generate a data from a list on excel. Basically I have a table on one worksheet and I have a list on another selecting the first value in each row. This bit works fine. What I am trying to do is generate the rest of the data on that row for the thing I select from the list. Please Help!! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to generate data from a list on excel from another workshe
Carole
Your'e welcome Regards Peter "carole" wrote: I tried what you said and it works now. Thank you very much. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| generate a list from a single row of data | Excel Discussion (Misc queries) | |||
| How do I query a List to generate source data for a chart? | Excel Worksheet Functions | |||
| How to generate a function from the given data list(Y and X) | Excel Worksheet Functions | |||
| generate a random number and use if function to generate new data | Excel Worksheet Functions | |||
| Compare worksheets and generate list of missing data? | Excel Worksheet Functions | |||
Hybrid Mode
