Alternate way to get around the "7 Nested IF" restriction in Excel?

[NathanBWF]

I'm assuming there has to be another way to do this?

I need cell B1 to display a price depending on which option I choose from cell A1. Cell A1 is a drop down list (using validation) that has more than 7 options, which of course is where I run into trouble because I'm using nested IF statements and Excel has a limit of 7. I've tried using defined names but it doesn't seem to work...

TIA.

 

[NathanBWF]

Bah, think I got it using the VLOOKUP function...

 

[boran]

another thing you could do is use seperate subfields handeling a part of the if statement. (and then refering to those from the main field) but I think you might as well just use VBA (or try and find out) because it's getting complicated then.