Forum Discussion
Excel: Get cell address of a intersection.
I have a value in a row and a value in column.
Eg:
| Jan | Feb | Mar | Apr | |
| Region1 | 100 | 200 | 300 | 400 |
| Region2 | 100 | 200 | 300 | 400 |
| Region3 | 100 | 200 | 300 | 400 |
I need to get cell address of the intersections.
Eg: Region3->Mar
output: D4
How can i achieve this?
Address : D4
1 Reply
Hi,
You can do this using this formula:
=ADDRESS(MATCH(G2,A:A,0),MATCH(H2,1:1,0),4)
Please find it in the atttached file.
Regards
