DATA VALIDATION FORMULA TOO LONG

[JUANDIEGO101800]

Hi i am used to using data validation. Recently I was typing a formula and it seemed as it was too long due that I was unable to keep writting it. The following formula is :

=IF(AND(A32="BIO ORIENTADO ";A35="BAJA");'BASE DE DATOS'!$AA$2:$AA$5;IF(AND(A32="BIO ORIENTADO ";A35="ALTA ");'BASE DE DATOS'!AB2:AB5;IF(AND(A32="MONO ORIENTADO";A35="BAJA");'BASE DE DATOS'!AC2:AC7;IF(AND(A32="MONO ORIENTADO";A35="ALTA");'BASE DE DATOS'!$AD$2:$AD$5))))

What could I do in this case?

 

[jasonb75]

Try entering "BIO ORIENTADO BAJA" into AA1, then repeat in AB1, AC1 and AD1 with the correct criteria for those columns, then use a formula like

=INDEX('BASE DE DATOS'!$AA$2:$AD$5;0;MATCH(A32&" "&A35;'BASE DE DATOS'!$AA$1:$AD$1;0))