Creating a Drop down list then linking another cell.


Alexa M.

Can I create a drop down list in a cell? If yes, how do I do that?

Then after I create the drop down list I want it so that when I pick
something from the drop down list the cell beside it will put in a price.

B1 B2
Reg $112.00

I want it to put the price in for me without me having to type it in.



L. Howard Kittle

You can use VLOOKUP to make that happen. The formula would look something
like this...


Where A1 is where the drop down list is.
Where column B is a list of the same things in the drop down list.
Where column C is the respective prices of the things in the drop down.


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