set-up with Excel

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.
 
B

Bob Phillips

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)
 
Top