Selecting a specific cell depending on user input

23Mat · 01-31-2023 06:09 AM

I have a table of data, and I would like to give the user the possibility to select two different parameters that would output a specific cell in the database. A bit like battleship game. For example this is the data table:

This is the data sheet

And this is the app view:

Now, the user is able to select two parameters from drop-down lists, and the output should be the corresponding cell. (7 in this example)

But I am having some troubles creating a formula that would deliver this output. I can easily make the user select the desired row, but I can't find a way to make the user determine from which column they would like to take data from. Any chance someone has any suggestion on how to get this working?

Thank you very much for any input or direction.

Marc_Dillon

You can't dynamically select a column based on data. You have to hard-code a full list in an IFS or SWITCH. Like:

SWITCH( [column] ,
  "col1" , [col1] ,
  "col2" , [col2] ,
  ...
)

23Mat

Thank you very much, I'll give it a try.