software

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 quot;MJT0606quot; 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.

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 amp; 2003

quot;TJquot; gt; wrote in message
...
gt; We use excell to do quotes. I would like to have a work book that has all
gt; of
gt; my part numbers / descriptions / list price, then access this from my
gt; quote
gt; sheet. example
gt; column A Column B Column C
gt; part number description list price
gt; MJT0606 MJ C153 TEE L/A $48.93
gt; MJT0404 MJ C153 TEE L/A $42.63
gt;
gt; I would like to be able to enter my part number quot;MJT0606quot; and it refrence
gt; the description and price from another worksheet, and automatically
gt; populate
gt; the adjacent cells. Presently we are typing all of the information every
gt; time.
gt;
gt; What function within excell can I use to do this.
On Fri, 10 Mar 2006 08:00:30 -0800, TJ gt;
wrote:

gt;We use excell to do quotes. I would like to have a work book that has all of
gt;my part numbers / descriptions / list price, then access this from my quote
gt;sheet. example
gt;column A Column B Column C
gt;part number description list price
gt;MJT0606 MJ C153 TEE L/A $48.93
gt;MJT0404 MJ C153 TEE L/A $42.63
gt;
gt;I would like to be able to enter my part number quot;MJT0606quot; and it refrence
gt;the description and price from another worksheet, and automatically populate
gt;the adjacent cells. Presently we are typing all of the information every
gt;time.
gt;
gt;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

HTHRichard Buttrey
__