Is there a way to search for an exact match within an array of data and return the row and/or column of the match? The formula is to go in cells B2 and B3 in the first table.
<tbody>
</tbody>
<tbody>
</tbody>
Search term: | 45 |
Result (column): | 4 |
Result (row): | 3 |
<tbody>
</tbody>
23 | 43 | 37 | 23 | 67 |
67 | 88 | 87 | 24 | 54 |
74 | 24 | 56 | 45 | 88 |
76 | 24 | 56 | 98 | 65 |
21 | 34 | 79 | 76 | 43 |
<tbody>
</tbody>