Forum Discussion
Solved
Spreadsheet Help with Formulas Across Several Columns
In cell B5 it currently says 3 Foot. In different scenarios it can also say 6 Foot or Even. I need cell C7 to reference the appropriate column on tab 1C in regards to Even, 3 Foot, or 6 Foot, then ...
One possible solution:
=INDEX('1C'!A:D,LOOKUP(B7,'1C'!A2:A509,ROW('1C'!C2:C509)),MATCH(B5,'1C'!1:1,0))
In regards to your inquiry about creating a drop down selection list in excel.
Type the words Even, 3 Foot and 6 Foot (in three separate cells) on another area of your spreadsheet, then - once you're in the cell where you want the list - go to Data Tab>Data Validation dropdown>Data Validation>Allow dropdown>List>Data dropdown> Choose the list you typed earlier. Hit OK.
Type the words Even, 3 Foot and 6 Foot (in three separate cells) on another area of your spreadsheet, then - once you're in the cell where you want the list - go to Data Tab>Data Validation dropdown>Data Validation>Allow dropdown>List>Data dropdown> Choose the list you typed earlier. Hit OK.