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.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
quot;Palendromedaryquot; wrote:
gt; Hi,
gt; I am trying to put together a spreadsheet where I can type in a part number
gt; and excel fills in the details (description, list price, cost price) which it
gt; gets from other sheets in the same workbook. Unfortunately I don't know what
gt; this is called or if it can be done. Any help would be really appreciated.
gt;
Chuck you're a star. Have a great Christmas
Thanks
quot;CLRquot; wrote:
gt; The feature you seek is called VLOOKUP. Check out the HELP file for it and
gt; if you have questions, post back here for more help.
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;Palendromedaryquot; wrote:
gt;
gt; gt; Hi,
gt; gt; I am trying to put together a spreadsheet where I can type in a part number
gt; gt; and excel fills in the details (description, list price, cost price) which it
gt; gt; gets from other sheets in the same workbook. Unfortunately I don't know what
gt; gt; this is called or if it can be done. Any help would be really appreciated.
gt; gt;
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
quot;Palendromedaryquot; wrote:
gt; Chuck you're a star. Have a great Christmas
gt;
gt; Thanks
gt;
gt; quot;CLRquot; wrote:
gt;
gt; gt; The feature you seek is called VLOOKUP. Check out the HELP file for it and
gt; gt; if you have questions, post back here for more help.
gt; gt;
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Palendromedaryquot; wrote:
gt; gt;
gt; gt; gt; Hi,
gt; gt; gt; I am trying to put together a spreadsheet where I can type in a part number
gt; gt; gt; and excel fills in the details (description, list price, cost price) which it
gt; gt; gt; gets from other sheets in the same workbook. Unfortunately I don't know what
gt; gt; gt; this is called or if it can be done. Any help would be really appreciated.
gt; gt; gt;
- Sep 29 Fri 2006 20:09
Fetching data from other sheets
close
全站熱搜
留言列表
發表留言