Macro or What If?

[culcab]

Using information in a cell from a pull down box along with other information from another pull down box and the combination of the two will = a value in a third cell.

Example:

A1 (as a pull down box) B1 (as a pull down box)

VG FS
CL FP
GBK NP
PBK WS

 

[culcab]

Some how posted without finishing.

Using information in a cell from a pull down box along with other information from another pull down box and the combination of the two will = a value in a third cell.

A1 could have a pull down box containing multiple Acronyms: VG, CL, GBK, PBK etc.

B1 could have a pull down box containing multiple Acronyms: FS, FP, NP, WS etc.

C1 would be a value assigned to a specific combination of A1 and B1

VG + FS = .87
VG + WS = 1.02

The value would be specific to the particular combination.

Any help would be appreciated.

Thanks,