| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fetching data from other sheets
Hi,
I am trying to put together a spreadsheet where I can type in a part number and excel fills in the details (description, list price, cost price) which it gets from other sheets in the same workbook. Unfortunately I don't know what this is called or if it can be done. Any help would be really appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Fetching data from other sheets
The feature you seek is called VLOOKUP. Check out the HELP file for it and
if you have questions, post back here for more help. Vaya con Dios, Chuck, CABGx3 "Palendromedary" wrote: Hi, I am trying to put together a spreadsheet where I can type in a part number and excel fills in the details (description, list price, cost price) which it gets from other sheets in the same workbook. Unfortunately I don't know what this is called or if it can be done. Any help would be really appreciated. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Fetching data from other sheets
Chuck you're a star. Have a great Christmas
Thanks "CLR" wrote: The feature you seek is called VLOOKUP. Check out the HELP file for it and if you have questions, post back here for more help. Vaya con Dios, Chuck, CABGx3 "Palendromedary" wrote: Hi, I am trying to put together a spreadsheet where I can type in a part number and excel fills in the details (description, list price, cost price) which it gets from other sheets in the same workbook. Unfortunately I don't know what this is called or if it can be done. Any help would be really appreciated. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Fetching data from other sheets
Thank you very much for your nice feedback, and a very Merry Christmas and
Happy New Year to you and yours as well. Vaya con Dios, Chuck, CABGx3 "Palendromedary" wrote: Chuck you're a star. Have a great Christmas Thanks "CLR" wrote: The feature you seek is called VLOOKUP. Check out the HELP file for it and if you have questions, post back here for more help. Vaya con Dios, Chuck, CABGx3 "Palendromedary" wrote: Hi, I am trying to put together a spreadsheet where I can type in a part number and excel fills in the details (description, list price, cost price) which it gets from other sheets in the same workbook. Unfortunately I don't know what this is called or if it can be done. Any help would be really appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
| Multiple worksheet queries | Excel Worksheet Functions | |||
| Linking sheets when sorting row and column data | Excel Worksheet Functions | |||
| Fetching External Data from Excel | Excel Discussion (Misc queries) | |||
Linear Mode
