Excel: Get cell address of a intersection.

[srikanth diddy]

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

[#2]

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