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
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