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.

Example:
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...

=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