| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting formula in data validation list | Excel Worksheet Functions | |||
| Indirect formula using Data Validation List of Worksheet Tabs | Excel Worksheet Functions | |||
| Help required - Data - Validation - List - Formula | New Users to Excel | |||
| HELP: Data > Validation ---List ----Formula | Excel Worksheet Functions | |||
| Setting up a random list from long list of names ? | Excel Discussion (Misc queries) | |||
Hybrid Mode
