Nested IF

[Amjad]

How can I overcome the limitation of having up to only 7
levels of nested IF functions?
I want to display a name in a cell that corresponds to a
number in another cell, and I have 16 numbers.
e.g. =If(A1=1,"Name1",If(A2=2,"Name2",If(...

 

[Don Guillett]

how about using choose or vlookup
=choose(a1,"name1","name2",etc)

 

[mab042]

Create a lookup list and use a lookup function.

Marc