Creating a Drop down list then linking another cell.

  • Thread starter Thread starter Alexa M.
  • Start date Start date
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.
 
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
 
Back
Top