Link cell value to value in Combo Box

[nirvehex]

Hi,

I have a drop down combo box with a list of numbers in it, 400,500,600,700. When I link it to a cell value in the properties, the cell value only shows the number selection instead of the actual value. For example it will show 1 in the linked cell if 400 is selected, 2 if 500 is selected, and 3 if 600 is selected, etc.

How do I change it so it shows the value instead?

Thanks.

 

[nirvehex]

Figured it out. The cell link in the properties only gives you the number value of your drop down selection. Use this number to perform a vlookup against to return the actual value you want.