drop down list in excel

G

Guest

has anyone linked pricing in drop down list.
so a user can pick the product from a list and the pricing would display and
link in a separate cell?
i am trying to build a bid program for my company in excel
 
B

Bob Phillips

You need a lookup table of products and prices, and use VLOOKUP the selected
value into that table.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 

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

Similar Threads

Conditional Drop Down List 1
Pick from drop-down list gives empty or erroneous result 6
How to dynamically change the list in drop down list based on thevalue of another cell? 1
EXCEL DROP DOWN 2
Define the Range of a drop-down list 5
Drop down menu / list 3
Should be quick and easy to do this in excel but drawing a blank 2
Excel Excel: How do I put a formula in a drop down list 11

Top