Drop down name Corresponding Price

I am very very green to excel. I am using Excel 2013. Normally I Just Google the issues I'm having but quite frankly I'm not sure what to search for.

I am making a spreadsheet that allows me to click the drop down box, Select a type of wood then put a corresponding price in another box.

I have the drop down box working but I cannot figure out to get a price associated with a selection on the drop down box.


Some projects use many different types of wood and sizes and I hope to be able to get the process a little more streamlined then pencil and paper. In the end I hope to have the spread sheet allow me to select from a database of woods. Then take the selections and enter different sizes to it. Have it calculate into board feet. Take the price that is associated with the selection of wood and apply it.

Any suggestions would be appreciated. Like I said, I have no clue what to search to find out how to do this.

You could either have a simple list of wood type and size, for example, pine 4x2, and have the price in the next column. You would use VLOOKUP for this approach. Or you could have a 2 dimensional matrix with the wood type down the left hand side and the sizes across the top. For this you would use INDEX/MATCH/MATCH.

Regards, TMS

Hi, welcome to the forum

If you have a list of sizes/prices, you could use a simple vlookup(), something like this...

	A	B	C
1	Size	Price	bb
2	aa	1	2
3	bb	2
4	cc	3
5	dd	4
6	ee	5

C1=your DD
C2=VLOOKUP(C1,$A$2:$B$6,2,0)