I have a 2-dimensional table and I need to select the value based on the values of the row and the column. A sort of (X,Y) coordinate as input and as output the text that is contained in the X,Y cell.
Example below
For the combination (a,2) I need to be able to extract tomato.
The rows and columns cannot be sorted to perform a vlookup.
Example below
a | b | c | d | |
1 | apple | pear | mango | ... |
2 | tomato | salad | ... | |
3 |
For the combination (a,2) I need to be able to extract tomato.
The rows and columns cannot be sorted to perform a vlookup.