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
__