| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get data from another worksheet
We use excell to do quotes. I would like to have a work book that has all of
my part numbers / descriptions / list price, then access this from my quote sheet. example column A Column B Column C part number description list price MJT0606 MJ C153 TEE L/A $48.93 MJT0404 MJ C153 TEE L/A $42.63 I would like to be able to enter my part number "MJT0606" and it refrence the description and price from another worksheet, and automatically populate the adjacent cells. Presently we are typing all of the information every time. What function within excell can I use to do this. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I get data from another worksheet
TJ, have a look at VLOOKUP in help
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "TJ" wrote in message ... We use excell to do quotes. I would like to have a work book that has all of my part numbers / descriptions / list price, then access this from my quote sheet. example column A Column B Column C part number description list price MJT0606 MJ C153 TEE L/A $48.93 MJT0404 MJ C153 TEE L/A $42.63 I would like to be able to enter my part number "MJT0606" and it refrence the description and price from another worksheet, and automatically populate the adjacent cells. Presently we are typing all of the information every time. What function within excell can I use to do this. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I get data from another worksheet
On Fri, 10 Mar 2006 08:00:30 -0800, TJ
wrote: We use excell to do quotes. I would like to have a work book that has all of my part numbers / descriptions / list price, then access this from my quote sheet. example column A Column B Column C part number description list price MJT0606 MJ C153 TEE L/A $48.93 MJT0404 MJ C153 TEE L/A $42.63 I would like to be able to enter my part number "MJT0606" and it refrence the description and price from another worksheet, and automatically populate the adjacent cells. Presently we are typing all of the information every time. What function within excell can I use to do this. Assuming the sample data above is on sheet 1and you enter your part number in A1 on sheet 2, then put in sheet 2 =VLOOKUP($A1,Sheet1!$A:$C,2,FALSE) in B1 and =VLOOKUP($A1,Sheet1!$A:$C,3,FALSE) in C1 HTH Richard Buttrey __ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy a graph and use the data in the new worksheet? | Charts and Charting in Excel | |||
| Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
| Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
| Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
| Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
Linear Mode
