Hello,
If i am having a table as follows, using excel formulas is there any way to find out the labels of the row and column of a selected value. For eg., if I select 21, the answer should come as 13-05-2013 (dd-mm-yyyy). or if I select 28, 15-06-2013.
<tbody>
</tbody>Please help.
If i am having a table as follows, using excel formulas is there any way to find out the labels of the row and column of a selected value. For eg., if I select 21, the answer should come as 13-05-2013 (dd-mm-yyyy). or if I select 28, 15-06-2013.
A | B | C | D | E | F | G | |
1 | MONTH/DATE | 11 | 12 | 13 | 14 | 15 | 16 |
2 | Apr-13 (mmm-yy) | 17 | 18 | H | H | H | 19 |
3 | May-13 | H | 20 | 21 | 22 | 23 | 24 |
4 | Jun-13 | 25 | H | 26 | 27 | 28 | H |
5 | July-13 | 29 | 30 | 31 | 32 | 33 | 34 |
<tbody>
</tbody>