I have a project am working on and i need your help in how to go about it. I have 3 drop down menus let’s call them drop-down 1, drop down 2, drop down 3, drop down 4 and i have an excel file with 10 columns of data as shown below in the diagram.
So what i am trying to accomplish is to embed this table into the form but in the background or hidden and then access each column.
when user selects meets these conditions:
1.if drop-down menu 1 = a
2.drop-down menu 2 =b
3.drop down menu = c, (this drop-down is dependent on drop-down menu 2)
4.then drop-down menu 4 should show list in column a or range