Need help picking right formula?

This is hard for me to explain. But here it goes.
A1=Widget1
A2=Left Handed
A3=Red
A4=Mod2
A5=PriceLevel2
A6=Unit Price

A1 through A5 you can select various options (e.g. A1 could Equal any one of the following: Widget1, Widget2, Widget3 or Widget4)

Trying to right a formula where a value could automatically be entered in A6 based on which values are in A1 to A5.

Example 1: A6=$500 if (A1=Widget1, A2=Left Handed, A3=Red, A4=Mod2, 5=PriceLevel2).

A6 would = $400 if ((A1=Widget3, A2=Right Handed, A3=White, A4=Mod2, 5=PriceLevel4).

Any suggestions.

You need to create some other tables with the options and the prices

the either by vlookup or sumproduct or combine the them to get a result

We do not know if the options differ in price for different models for example
If every option has 5 values and it is a combination of everything, so lets say metalic paint is not just £500 extra on any car you would have 5x5x5x5x5 =3125 values in the table and sumproduct would work best. We do not know if the options are additive of multiplicative. You need to provide some data and explain in a bit more detail

Regards

Dav