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 ...
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