Is it possible to nest more than 64 in one command?

[HeRoseInThree]

I have a LARGE nested formula. it works great, except I need it to be bigger.

=IF(AA4=AD16,AB4,IF(AA5=AD16,AB5,IF(AA6=AD16,AB6,IF(AA7=AD16,AB7,IF(AA8=AD16,AB8,IF(AA9=AD16,AB9,IF(AA10=AD16,AB10,IF(AA11=AD16,AB11,IF(AA12=AD16,AB12,0)))))))))))))

I need it to be up to 99. Is there a way???

Thanks so much!!!

 

[Eric W]

Nesting IFs so deep is almost NEVER the best way to do things. You should look at the LOOKUP type functions. Your formula can be rewritten as:

=VLOOKUP(AD16,$AA$4:$AB$99,2,0)

Much shorter!

 

[Fluff]

How about
=INDEX(AB4:AB100,MATCH(AD16,AA4:AA100,0))

 

[HeRoseInThree]

Nesting IFs so deep is almost NEVER the best way to do things. You should look at the LOOKUP type functions. Your formula can be rewritten as:

=VLOOKUP(AD16,$AA$4:$AB$99,2,0)

Much shorter!

HOLY CRAP! I really LOVE the vlookup formula - no idea why I didn't think of it!

THANK YOU SO MUCH!!!!!!!!!!!

 

[Eric W]

Glad we could help!

 

[HeRoseInThree]

How about
=INDEX(AB4:AB100,MATCH(AD16,AA4:AA100,0))

This works too!

THANKS!!!!!!

 

[Fluff]

You're welcome