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.

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.

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.

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.