importing and automating look up auto-fill

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am attempting to make an automated excel quotation package, I have an excel
price list that shows list price only. I would like to import the price list
to my quote package and have it automatically fill in descriptions and each
price as I type in the part number. I am not overly familiar with excel and
have rarely had a need to use it, and now that I do I do not know how to go
about it. Can anyone help me with this as it is frustrating. Thank's in
anticipation John.p.
 
You use a lookup function. if the list of parts is in order use
Vlookup(cell,list,offsetvalue) where cell if the part to lookup, list is the
list of parts and offset is the column offset for the the price.if the part
is in column a and the price is in column B then the offset value is 2.
 
I am in the process of doing the same thing John. One thing that you have to
watch out for is the relative cell references when you copy to other cells.
In my sheet, I had to make the column reference absolute.
 
Just set up two worksheets, one being the quote sheet and the other one being
the look up table. The lookup table will have three columns (or however many
you want). Enter part number in col A, description in col B, and price in col
C.

On the first sheet (the actual quote), set up the columns however you want.
The user will enter the part number where appropriate. In the subsequent
cells, use the VLOOKUP function and have the formula match the part number on
sheet one with the line in sheet two where it appears. Then direct it to
take the value from whatever adjacent cell you need, ie. desc, price, etc.
This is done in the syntax of VLOOKUP. Should be pretty easy.

Mike
 
Back
Top