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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Maybe a vlookup would be sufficient

=VLOOKUP(value_from_dropdown,Lookup_Table,2,0)

--
Regards,

Peo Sjoblom

(No private emails please)
 
Back
Top