Work around to the 7 function limit with the IF function

[Venka]

I'm comfortable with the IF statements in excel and not familir with many of the other functions available to me. I am trying to create a character calulator for Elder Scrolls III (Marrowind). So that a person may enter their race, ***, and other choices and their by calculating all starting stats. There are 10 races you can choose from and I can cover 9 of them with the if function (leaving one as if all other options are false). I would like to know if there is a better way such as a drop down list or some way to search an array or anything that would be better suited to search the race cell and return data if it's true. I'm running into the same probably with choosing the constalation (13 choices in this catagory). I thought to split it two different data fields, by letting you choose from 4 in one cell and the other 9 in a different cell, but realized I don't know how to make it check two different cells for a choice to return it to the display cell without hitting the limitation of the 7 nested funcations in a forumla again.

I have attached the worksheet for review and help. Thank you guys in advance for your time and help. I'm open to any options that will help me.

[Bob Phillips]

Try formulae such as

=INDEX(AE1:AE11,MATCH(C16,B1:B11,0))

in A26

[VBA Noob]

If you want to replace this formula

=IF(C16=B3,C3,IF(C16=B4,C4,IF(C16=B5,C5,IF(C16=B6,C6,IF(C16=B8,C8,IF(C16=B9,C9,IF(C16=B10,C10,IF(C16=B11,C11,C7))))))))

try this

=INDEX($C$2:$C$11,MATCH(C16,$B$2:$B$11,0))

VBA Noob

[Venka]

Thank you both so much, that works wonders =)