Assuming your row number is in B1, you can use INDIRECT:
=INDIRECT("A" & B1)
This takes a cell reference as a string (in this case, the concatenation of A and the value of B1 – 5), and returns the value at that cell.
Assuming your row number is in B1, you can use INDIRECT:
=INDIRECT("A" & B1)
This takes a cell reference as a string (in this case, the concatenation of A and the value of B1 – 5), and returns the value at that cell.