I'm creating a spreadsheet for calculating costs of crafting in a game to determine profit ratios. There is a section of my spreadsheet where I would like to have a two drop down lists. In the first one I would like to select the column title of a table, and in the second I'd like to select the row title of a table. In a third cell I would like to use the value in the cell located at this intersection in a formula. I'm sure there has to be a way to do this, but I haven't found anything quite like it with Google. All the drop down list dependency tutorials I've found use different methods that don't suit my situation. Thanks very much.
Ok without resorting to VBA scripting, you'll have to make two small tables, of two columns each, the first column being the index and the second being the row / column title.
So lets assume your original table has 5 rows and 3 columns with simple titles such as Row1, Row2, Row3, Row4, Row5 and Col1, Col2, Col3. And this table starts from
So you'll have something like this:
Next in the Developer tab on the ribbon, click
If you are not in Design Mode, click Design Mode.
Basically, through the
Note: For the rows, you could add a column to the right of the existing row titles and enter the row indices (and hide the column). But for columns, you have to create a new table, because the