Move data from one sheet to another using drop down lists.

G

Guest

I am creating an accounting spreadsheet in excel 2003. One of the sheets is
all the inventory that we use. One column has the product, the next column
has our cost and the third column has our retail price via a formula. On a
seperate sheet that we use to creat a quote, I have a drop down list from our
inventory sheet. When I select a piece of inventory i would like excel to
fill in our retail cost that corresponds with that part in the inventory list
in a retail cost field in our quote sheet. Is this possible and if so how??
thanks
 
P

Peo Sjoblom

Maybe a vlookup would be sufficient

=VLOOKUP(value_from_dropdown,Lookup_Table,2,0)

--
Regards,

Peo Sjoblom

(No private emails please)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top