How do I tie prices to a drop down list of products in excel?
Assuming that the prices are precede by the product in the form of a lookup
table, you can use VLOOKUP
=VLOOKUP(A1,$M$1:$N$20,2,False)
where A1 is the DV cell, M1:N20 is the lookup table
--
HTH
RP
(remove nothere from the email address if mailing direct)
"trspds" wrote in message
...
How do I tie prices to a drop down list of products in excel? I have a
column
of products that I turned into a drop down box and I have a column of
prices
that I want to fill in when I select an item from the drop down list.
|