Hello, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
Here is my problem: <o
></o
>
Excel spreadsheet will contain a form that will consist of drop down boxes (data validation). Each drop down box will define the data that can be selected in the next drop down box. <o
></o
>
<o
></o
>
The way I initially went about it, is creating nested IF statements. However, we all know there is a limit of 7 nested IF statements. I have 10! So below formula does not work:<o
></o
>
=if(B5=1,F5:I5, if(B5=2, F6:I6, if(B5=3, F7:H7, if(B5=4, F8:J8, if(B5=5, F9:H9, if(B5=6,F10:G10, if(B5=7,F11:H11, if(B5=8,F12:H12, if(B5=9, F13:I13, if(B5=10, F14:K14))))))))))<o
></o
>
<o
></o
>
I tried other workarounds such as CONCATENATE, or & signs. No luck. VLOOKUP does not work also, because there are multiple columns in col_index_num. Anything else I try gives me this message:<o
></o
>
“The List Source must be a delimited list, or a reference to a single row or column”<o
></o
>
<o
></o
>
What should really happen is this:<o
></o
>
User selects value in first list box. Second list box shows values associated wih the value from the first drop down only. <o
></o
>
<o
></o
>
<o
>
</o
>
Here is my problem: <o
Excel spreadsheet will contain a form that will consist of drop down boxes (data validation). Each drop down box will define the data that can be selected in the next drop down box. <o
<o
The way I initially went about it, is creating nested IF statements. However, we all know there is a limit of 7 nested IF statements. I have 10! So below formula does not work:<o
=if(B5=1,F5:I5, if(B5=2, F6:I6, if(B5=3, F7:H7, if(B5=4, F8:J8, if(B5=5, F9:H9, if(B5=6,F10:G10, if(B5=7,F11:H11, if(B5=8,F12:H12, if(B5=9, F13:I13, if(B5=10, F14:K14))))))))))<o
<o
I tried other workarounds such as CONCATENATE, or & signs. No luck. VLOOKUP does not work also, because there are multiple columns in col_index_num. Anything else I try gives me this message:<o
“The List Source must be a delimited list, or a reference to a single row or column”<o
<o
What should really happen is this:<o
User selects value in first list box. Second list box shows values associated wih the value from the first drop down only. <o
<o
<o
![excel.jpg](/board/proxy.php?image=http%3A%2F%2Fwww.collectorthrills.com%2Fexcel.jpg&hash=add7b6c307c8dc64306c8e13a19a693a)
Last edited: