How do I get data from another worksheet

[Guest]

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.

 

[Paul B]

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

 

[Richard Buttrey]

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
__