Formula too Long for List Validation
 

The formula I need to enter as the source in a List Validation is:

=INDIRECT(CHOOSE(VLOOKUP(L10,AE1:AF53,2),AG1,AG2,A G3,AG4,AG5,AG6,AG7,AG8,AG9,AG10,AG11,AG12,AG13,AG1 4,AG15,AG16,AG17,AG18,AG19,AG20,AG21,AG22,AG23,AG2 4,AG25,AG26,AG27,AG28,AH29,AG30,AG31,AG32,AG33,AG3 4,AG35,AG36,AG37,AG38,AG39,AG40,AG41,AG42,AG43,AG4 4,AG45,AG46,AG47,AG48,AG49,AG50,AG51,AG52,AG53))

but of course it's too long to fit in the validation source field :(

I thought I could shorten it by using:
=INDIRECT(CHOOSE(VLOOKUP(L10,AE1:AF53,2),AG1:AG53) ) instead, but that doesn't
work :(

Is there anyway to shorten it and still get the same results?
I really appreciate any help I can get with this...thanks!

Formula too Long for List Validation
 

Maybe this:

=INDIRECT(INDEX(AG1:AG53,MATCH(L10,AE1:AE53)))

Biff

"JB" wrote in message
...
The formula I need to enter as the source in a List Validation is:

=INDIRECT(CHOOSE(VLOOKUP(L10,AE1:AF53,2),AG1,AG2,A G3,AG4,AG5,AG6,AG7,AG8,AG9,AG10,AG11,AG12,AG13,AG1 4,AG15,AG16,AG17,AG18,AG19,AG20,AG21,AG22,AG23,AG2 4,AG25,AG26,AG27,AG28,AH29,AG30,AG31,AG32,AG33,AG3 4,AG35,AG36,AG37,AG38,AG39,AG40,AG41,AG42,AG43,AG4 4,AG45,AG46,AG47,AG48,AG49,AG50,AG51,AG52,AG53))

but of course it's too long to fit in the validation source field :(

I thought I could shorten it by using:
=INDIRECT(CHOOSE(VLOOKUP(L10,AE1:AF53,2),AG1:AG53) ) instead, but that
doesn't
work :(

Is there anyway to shorten it and still get the same results?
I really appreciate any help I can get with this...thanks!

Formula too Long for List Validation
 

IT WORKED PERFECTLY!!! THANK YOU SO MUCH!!!!

"T. Valko" wrote:

Maybe this:

=INDIRECT(INDEX(AG1:AG53,MATCH(L10,AE1:AE53)))

Biff

"JB" wrote in message
...
The formula I need to enter as the source in a List Validation is:

=INDIRECT(CHOOSE(VLOOKUP(L10,AE1:AF53,2),AG1,AG2,A G3,AG4,AG5,AG6,AG7,AG8,AG9,AG10,AG11,AG12,AG13,AG1 4,AG15,AG16,AG17,AG18,AG19,AG20,AG21,AG22,AG23,AG2 4,AG25,AG26,AG27,AG28,AH29,AG30,AG31,AG32,AG33,AG3 4,AG35,AG36,AG37,AG38,AG39,AG40,AG41,AG42,AG43,AG4 4,AG45,AG46,AG47,AG48,AG49,AG50,AG51,AG52,AG53))

but of course it's too long to fit in the validation source field :(

I thought I could shorten it by using:
=INDIRECT(CHOOSE(VLOOKUP(L10,AE1:AF53,2),AG1:AG53) ) instead, but that
doesn't
work :(

Is there anyway to shorten it and still get the same results?
I really appreciate any help I can get with this...thanks!

Formula too Long for List Validation
 

You're welcome. Thanks for the feedback!

Biff

"JB" wrote in message
...
IT WORKED PERFECTLY!!! THANK YOU SO MUCH!!!!

"T. Valko" wrote:

Maybe this:

=INDIRECT(INDEX(AG1:AG53,MATCH(L10,AE1:AE53)))

Biff

"JB" wrote in message
...
The formula I need to enter as the source in a List Validation is:

=INDIRECT(CHOOSE(VLOOKUP(L10,AE1:AF53,2),AG1,AG2,A G3,AG4,AG5,AG6,AG7,AG8,AG9,AG10,AG11,AG12,AG13,AG1 4,AG15,AG16,AG17,AG18,AG19,AG20,AG21,AG22,AG23,AG2 4,AG25,AG26,AG27,AG28,AH29,AG30,AG31,AG32,AG33,AG3 4,AG35,AG36,AG37,AG38,AG39,AG40,AG41,AG42,AG43,AG4 4,AG45,AG46,AG47,AG48,AG49,AG50,AG51,AG52,AG53))

but of course it's too long to fit in the validation source field :(

I thought I could shorten it by using:
=INDIRECT(CHOOSE(VLOOKUP(L10,AE1:AF53,2),AG1:AG53) ) instead, but that
doesn't
work :(

Is there anyway to shorten it and still get the same results?
I really appreciate any help I can get with this...thanks!