formula that will show the cell address

i want a formula that will show the cell address in H3 when i put data in cell B3:F3 and so on.
please note that only one cell will be filled up in B3:F3.

i have attached a example sheet.

I think you have copied your data from another file, as the cell references do not tie up.

Anyway, you can use this in H4:

=ADDRESS(ROW(),MATCH(LOOKUP(9E+99,A4:F4),A4:F4),4)

then copy down.

Hope this helps.

Pete

=address(row(),max(index((b4:f4<>"")*column(b4:f4),0)))

Dear Pete,

Thank you very very much formula, both works fine. But please help me understand the difference between two formulas. which one will be i best for me.
Also sorry for mistake in cell address column example. it will be as below (as per your formula result)

D4
C5
E6
B7

Dear nflsales,

your formula also works fine

If both formulae give the same results, then use whichever one you feel most comfortable with.

Both formulae use the ADDRESS function, and the ROW function - the only difference is the way in which the COLUMN element is determined.

Hope this helps.

Pete

thanks nflsales

Dear Pete,

Thank you brother.

I don't think there would be much difference in speed. Incidentally, you can change LARGE ... 1 ... to MAX.

Hope this helps.

Pete