PDA

View Full Version : [SOLVED] Return Column / Row name of active cell



Sir Babydum GBE
08-14-2014, 03:23 PM
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
08-14-2014, 11:20 PM
Attach please a sample file with notes and desired output

Sir Babydum GBE
08-15-2014, 01:43 AM
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
08-15-2014, 05:58 AM
check attached

shrivallabha
08-15-2014, 06:11 AM
You could try following.
In B1:

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

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

Sir Babydum GBE
08-15-2014, 12:04 PM
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
08-15-2014, 04:12 PM
"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.....