how do I create drop boxes
 

I have been trying to create a drop box that when, Example: when I select
"Brick" that will generate a number 7 in a cell that will be calculated by a
nother cell.

how do I create drop boxes
 

I think the easiest way may be data|validation and then =vlookup() in that other
cell.

Debra Dalgleish describes both at:
http://www.contextures.com/xlDataVal01.html
and
http://www.contextures.com/xlFunctions02.html

Terry wrote:

I have been trying to create a drop box that when, Example: when I select
"Brick" that will generate a number 7 in a cell that will be calculated by a
nother cell.

--

Dave Peterson