Return Column / Row name of active cell

[Sir Babydum GBE]

Hi, using formulae, how can I return the value of column A in the currently active row, and also how do I return value of Row 3 in currently active column

Explanation. I can't use VBA because this has to work on Excel for iPad. So I have table headers in Row 3, and descriptions in Column A. The user will select a value from a drop-down list lets say for example its in Cell Q10. His selection causes excel to recalculate. So in B1 i need to return the value found in $A10, and in C1 I need to return the value found in Q$3

Thanks

[patel]

Attach please a sample file with notes and desired output

[Sir Babydum GBE]

OK,, here's a dummy sheet showing the help i need.

If it cant be done with formulas please let me know so that I can scrap this functionality in my workbook

Thx!

[patel]

check attached

[shrivallabha]

You could try following.
In B1:

=INDEX(A1:A24,CELL("row"))

In C1:

=INDEX(A3:G3,1,CELL("col"))

[Sir Babydum GBE]

Thanks Patel

a man of few words, but your answer works perfectly. Thank you.

"my dad was a man of few words. One day, he said to me: 'Son...' " — Stuart Francis

[Aussiebear]

"my dad was a man of few words. One day, he said to me: 'Son...' " — Stuart Francis

I can't wait for the movie to come out.....