Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation Source Box
I am looking for a help how to create a drop-down list using some functions
in a source box. I am using IF function but it seems that a number of "IF" used is limited to 6. I have tried to use instead of too much IFs (I need 11) a table and Lookup Function but when using it I receive a message "The list source must be a delimited list, or a reference to single row or column." If I put the whole formula (=VLOOKUP(CONCATENATE(H12,"_",H13),AA2:AB11,2)) to the source box the Excel takes it as a text and not as a range name. I do not know how to make the Excel to take this formula as a range name. The reason for all of this is that I need to make a choise from 10 different list on a base of entries in two fields. These to fields are arguments which list has to be chosen. Thanks a lot. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation Source Box
Hi
Remove the outer set of brackets, they are not required. =VLOOKUP(CONCATENATE(H12,"_",H13),AA2:AB11,2) Regards Roger Govier Drahos wrote: I am looking for a help how to create a drop-down list using some functions in a source box. I am using IF function but it seems that a number of "IF" used is limited to 6. I have tried to use instead of too much IFs (I need 11) a table and Lookup Function but when using it I receive a message "The list source must be a delimited list, or a reference to single row or column." If I put the whole formula (=VLOOKUP(CONCATENATE(H12,"_",H13),AA2:AB11,2)) to the source box the Excel takes it as a text and not as a range name. I do not know how to make the Excel to take this formula as a range name. The reason for all of this is that I need to make a choise from 10 different list on a base of entries in two fields. These to fields are arguments which list has to be chosen. Thanks a lot. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation Source Box
I'm thinking you may need to use the indirect function, but don't have time
to put in more details. "Drahos" wrote in message ... I am looking for a help how to create a drop-down list using some functions in a source box. I am using IF function but it seems that a number of "IF" used is limited to 6. I have tried to use instead of too much IFs (I need 11) a table and Lookup Function but when using it I receive a message "The list source must be a delimited list, or a reference to single row or column." If I put the whole formula (=VLOOKUP(CONCATENATE(H12,"_",H13),AA2:AB11,2)) to the source box the Excel takes it as a text and not as a range name. I do not know how to make the Excel to take this formula as a range name. The reason for all of this is that I need to make a choise from 10 different list on a base of entries in two fields. These to fields are arguments which list has to be chosen. Thanks a lot. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation Source Box
Roger and Barb,
both of you are right. This formula works: =INDIRECT(VLOOKUP(CONCATENATE(H12,"_",H13),AA2:AB1 1,2)) Thanks a lot for help. Drahos. "Drahos" wrote: I am looking for a help how to create a drop-down list using some functions in a source box. I am using IF function but it seems that a number of "IF" used is limited to 6. I have tried to use instead of too much IFs (I need 11) a table and Lookup Function but when using it I receive a message "The list source must be a delimited list, or a reference to single row or column." If I put the whole formula (=VLOOKUP(CONCATENATE(H12,"_",H13),AA2:AB11,2)) to the source box the Excel takes it as a text and not as a range name. I do not know how to make the Excel to take this formula as a range name. The reason for all of this is that I need to make a choise from 10 different list on a base of entries in two fields. These to fields are arguments which list has to be chosen. Thanks a lot. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DATA VALIDATION with LEFT function | Excel Discussion (Misc queries) | |||
Data Validation | Excel Discussion (Misc queries) | |||
Data Validation | Excel Worksheet Functions | |||
data validation | Excel Worksheet Functions | |||
Adding more source data to existing scatter plot | Charts and Charting in Excel |