Two dimensional lookup

Hi

I have a two dimensional grid, where I wish to extract row and column name for each value in the grid that > 0 (hence, if value <= 0, then blank).

In the attached example, the result that I want is shown in range G3:I21. So what I want is to get the result (i.e. Range(G3:I21) dynamically, when the two dimensional grid changes its input values. (note that I don't wish to sum the values).

I appreciate any help.

Put the below formula in cell I3 and copy down.

Formula:

Please Login or Register  to view this content.

BSB

How about column G, and column H? I need to fill those as well