Nesting Issue

[nadjadee]

I need to be able to add 28 more entries like the ones below. Can anyone help me with a formula? I know there is a way to section off the formula and then have it add together, but I'm not advanced enough to know how to do that.

=IF((C4="Nadja"),122,IF((C4="Lu"),105,IF((C4="Nancy"),104,IF((C4="Nana"),103,IF((C4="Erin"),101,IF((C4="Jill"),102,IF((C4="Mari"),121,IF((C4="Shoko"),106,""))))))))

The additions would be:
Michael 109
Yoko 110
David Mar 111
Shigeko 112
Arthur 113
Chris 114
Jessica 115
Brian 116
Steve 117
Jerry 123
Masako 118
Jeff 119
Deli 1 219
Deli 220
Grocery 222
Ayaka 223
Cindy 224
Fang 225
Maria 227
Stephanie 228
Lotto 888

[shg]

See http://www.contextures.com/xlfunctions02.html

[nadjadee]

See http://www.contextures.com/xlfunctions02.html

Thank you for responding. I have no idea how this link helps me, or where on the page to look for the formula I need. Again, I am not an excel pro.

[pike]

Hi nadjadee

in this case you dont have to use the ifs at all
=(C4="Nadja")*122+(C4="Lu")*105+(C4="Nancy")*104+(C4="Nana")*103+(C4="Erin")*101+( C4="Jill")*102+(C4="Mari")*121+(C4="Shoko")*106

[pike]

or just for intrest

=CHOOSE((C4="Nadja")*1+(C4="Lu")*2+(C4="Nancy")*3+(C4="Nana")*4+(C4="Erin")*5+(C4="Jill")*6+(C4="Mari")*7+(C4="Shoko")*8,"One","Two","Three","four","five","six","seven","Eight")

[nadjadee]

I say this with sincere honesty, Pike, you are a genius. Thank you so much.

[pike]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[nadjadee]

Done. And thanks!