Populate Worksheet from Drop Down Menu Selection

Sorry if anyone has already asked a question such as this... This is my first post. At any rate, I have a spreadsheet that I want to prepopulate pricing based on a selection made from a drop down menu that I created.

For example:

If in the drop down list, the day of the week is Friday and the month of the year (from another drop down list) is October, I want to populate a cell with a price that is based on the selections made from the two drop down lists.

Is there a way to do this with built in functions/formulas? Or do I need to use Visual Basic? If I need to use VB, can anyone give a tip on how to get started. It's been a while since I've used VB and I'm sure my syntax is incorrect.

I started with something like this:

Please Login or Register  to view this content.

Not even sure my syntax is right and I think there are different or better ways to handle '&' in VB.

Any help would be greatly appreciated. Thanks.