Creating a Drop down list then linking another cell.


A

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.

Example:
B1 B2
Reg $112.00

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

Advertisements

L

L. Howard Kittle

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

=VLOOKUP(A1,B1:C5,2,0)

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.

HTH
Regards,
Howard
 

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