Dear all,
I would like to use Index Match function to return e.g. "6", whenever the "Column" equals 3, and the "row" equals a number between 40 and 59. How can I do this
Thank you
<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>
</tbody>
I would like to use Index Match function to return e.g. "6", whenever the "Column" equals 3, and the "row" equals a number between 40 and 59. How can I do this
Thank you
80-100 | 60-79 | 40-59 | 20-39 | 0-19 | |
3 | 4 | 5 | 6 | 7 | 8 |
2 | 1 | 2 | 3 | 4 | 5 |
3 | 4 | 5 | 6 | 7 | 8 |
<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>
</tbody>