Hi all,
Hoping you can help.
I have a 2 variable data table that has 10 rows of data and 8 columns. I have a value that I want to look up in the array and return the lowest value that is greater than or equal to the number that I want to look up. I found a way to do this within a column, but not within an array. I imagine there is a way to do with with index(match(, but I can't seem to figure it out or find an existing thread that addresses this.
I have posted a simplified example in the table below
For this example, the value that I want to look up is 100. The formula I am trying to create should return "Column 1" "Row 2" as the lowest value in the array that is greater than or equal to 100 is 105. For the results, I do not care if "Column 1" "Row 2" are returned in a single cell or in two adjacent cells.
If the lookup value is 107, the result should be "Column 2" "Row 3"
<tbody>
</tbody>
Any help is greatly appreciated!
Thanks,
Adam1988
Hoping you can help.
I have a 2 variable data table that has 10 rows of data and 8 columns. I have a value that I want to look up in the array and return the lowest value that is greater than or equal to the number that I want to look up. I found a way to do this within a column, but not within an array. I imagine there is a way to do with with index(match(, but I can't seem to figure it out or find an existing thread that addresses this.
I have posted a simplified example in the table below
For this example, the value that I want to look up is 100. The formula I am trying to create should return "Column 1" "Row 2" as the lowest value in the array that is greater than or equal to 100 is 105. For the results, I do not care if "Column 1" "Row 2" are returned in a single cell or in two adjacent cells.
If the lookup value is 107, the result should be "Column 2" "Row 3"
Formula | Column 1 | Column 2 |
Row 1 | 99 | 106 |
Row 2 | 105 | 80 |
Row 3 | 88 | 110 |
<tbody>
</tbody>
Any help is greatly appreciated!
Thanks,
Adam1988