Hi,
I have values in column J.
in cell H8, i have a row number 11 which is variable.
In cell G11, i want value of row no.11 of column J. as value in cell H8 is 11.
(a sample file is attached for further clarification)
Hi,
I have values in column J.
in cell H8, i have a row number 11 which is variable.
In cell G11, i want value of row no.11 of column J. as value in cell H8 is 11.
(a sample file is attached for further clarification)
Try
=INDIRECT("J" &H8)
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Hi @JohnTopley
Thanks a lot.
It worked perfectly
FormulaFormula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks