G
Guest
The formula I need to enter as the source in a List Validation is:
=INDIRECT(CHOOSE(VLOOKUP(L10,AE1:AF53,2),AG1,AG2,AG3,AG4,AG5,AG6,AG7,AG8,AG9,AG10,AG11,AG12,AG13,AG14,AG15,AG16,AG17,AG18,AG19,AG20,AG21,AG22,AG23,AG24,AG25,AG26,AG27,AG28,AH29,AG30,AG31,AG32,AG33,AG34,AG35,AG36,AG37,AG38,AG39,AG40,AG41,AG42,AG43,AG44,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!
=INDIRECT(CHOOSE(VLOOKUP(L10,AE1:AF53,2),AG1,AG2,AG3,AG4,AG5,AG6,AG7,AG8,AG9,AG10,AG11,AG12,AG13,AG14,AG15,AG16,AG17,AG18,AG19,AG20,AG21,AG22,AG23,AG24,AG25,AG26,AG27,AG28,AH29,AG30,AG31,AG32,AG33,AG34,AG35,AG36,AG37,AG38,AG39,AG40,AG41,AG42,AG43,AG44,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!