set-up with Excel

  • Thread starter Thread starter Bacchus
  • Start date Start date
B

Bacchus

Hi

I was wondering if I can set this up somehow.

If I type in a certain name of a product, would excel be able to
automatically put that price in a certain field on a regular basis. It
would save me all kinds of time so I would not have to look at my price
sheet all the time. I would also be able to keep better inventory records.

thanks. this would be great if I could pull this off.
 
Bacchus

Put the following in the cell you want the price to appear in

=INDEX(Selling_Prices,MATCH(B9,Products,0)

You need to have a table of the Selling Prices ranged with the name
"Selling_Prices" i.e. Top left hand side of the screen there is a box (just
above the columns) usually shows the co-ordinat that your cursor is in.
Highlight the Selling Prices area and type the name "Selling_Prices" into
this box - thats then a range name called Selling_Prices

B9 in the formula above will be the name of the product your trying to price

"Products" in the formula above is another Ranged Name, done the same as
Selling_Prices above except this time highlight the area where the products
are (you need a table of products and prices, say column A contains the
products and column B contains those product prices)

The result will give what you want, its simple really, I've learned all I
know from this groups - you don't really need college, just an internet
connection!

HTH
 
Assume the product is in A1, and your price details are on Price Sheet,
A1:H100, with the product id in A, price in say E, column 5, then you would
use

=VLOOKUP(A1,'Price Sheet'!$A$%1:$H$100,5,False)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Back
Top