My problem is as follows.
I am currently developing a spread sheet for my sales guys where I want them to be able to select a drop down arrow and choose an option. That part I have figured out no problem. I want the option they then pick (in one column) to have a $value show up in the next column adjacent to their selection. I have been able to get around this by using the if function, which is unfortunately only good for 2 selections.

My question is, how can I have multiple options in my drop down, and have the correct value show up? They will never be the same values.

Also, I am creating all of my options and values on a seperate sheet, with my main sheet being the sales sheet, this way everything can be hidden.

Thx