Shorten Excel formula

[Cherbaz]

I need to shorten this formula for a data validation list, please help...

=IF($C23=AE7,AE8:AE13,IF($C23=AF7,AF8:AF13,IF(C23=AG7,AG8:AG13,IF(C23=AH7,AH8:AH13,IF(C23=AI7,AI8:AI13,IF(C23=AJ7,AJ8:AJ13,IF(C23=AK7,AK8:AK13,IF(C23=AL7,AL8:AL13,IF(C23=AM7,AM8:AM13,IF(C23=AN7,AN8:AN13,IF(C23=AO7,AO8:AO13,IF(C23=AP7,AP8:AP13,IF(C23=AQ7,AQ8:AQ13,IF(C23=AR7,AR8:AR13,IF(C23=AS7,AS8:AS13,IF(C23=AT7,AT8:AT13)))))))))))))))

 

[Aladin Akyurek]

Looks like:

=INDEX(AE8:AT13,0,MATCH(C23,AE7:AT7,0))

 

[Cherbaz]

Looks like:

=INDEX(AE8:AT13,0,MATCH(C23,AE7:AT7,0))

That worked perfect.... You're kind. Thanks!

 

[Aladin Akyurek]

That worked perfect.... You're kind. Thanks!

You are welcome.