Ok a new twist to my previous question. I have a drop down list with the size of blocks in cell A1, in cell B1 is # of Blocks, in cell C1 I want a unit price to be automatically populated once a selection is made from cell A1, in cell D1 is a cost formula (=B1*C1). I assume that I will need to set up a column of unit prices somewhere else in the spreadsheet so that C1 has something to reference. I'm just not sure what the formula is to insert into C1 so that it recognizes the selection in A1 and populates the corresponding unit price.

Thanks in advance