Excel 2007 : Creating a usable Work Sheet For Orders

Im trying to make a user friendly sheet for my company to place cabinet orders
I want to know how to have a list of cabinets and prices and be able to enter the name of a cabinet and the Dollar amount pop up next to it
I also want to know if there is a way to set it up to work for all 10 styles - So for a quote i can hit Oak and have it give the price for oak only.
Thanks for any Help - Please look at John B1 its a quick view of what im working on
Currently Working on the Data Sheet Cabinet Order Form Final.xlsx

Welcome to the forum,

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST

ok, this makes a bit more sense to me. you can still use the vlookup for your price, but you would need to create a complete list of sizes/styles to look up against. for example one column would have style/size like this "CherryW3630" and the second would have the price, when you do the vlookup you combine the selected style, with the size, and look that up against your newly created table.

assuming table is located in range R:S and you style selction was in cell A6, your formula for C9 would be:

=VLOOKUP(A6&A9,R:S,2,0)

again this is dependent on a table containing all possible size and style options.

EDIT:
i forgot to add that the list would be a concatenation of both style and size, with price in the second column.

You would physically type MW3030LO in A9 and then in the adjacent cell you enter formula:

=VLOOKUP(A9,$R:$S,2,0)

to get the retail price from the list.

please remember to mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save