formula results question

[Ken]

Can someone tell me how to use the results of a function to determine a cell number? This is hard to explain, but hopefully easy to answer

I need to determine which row I am in, and use that number as the row in another formula

Exampl

I am using =A4 as a formula. But I need to dynamically change the "4" to the ROW() function and insert it back into =A4

Does this make sense, and does anyone know how to do it

Thank you

Ken

 

[JE McGimpsey]

One way among many:

=INDEX(A:A,ROW())

or

=OFFSET(A1,ROW()-1,0)

or

=INDIRECT("A" & ROW())

 

[green78]

I can hardly understand what you exactly mean but I think I can hel
you. Check the function =INDIRECT()

Basically this function means - if you have the following values:

A1 = "5"
B1 = "A1"

then if in cell C1 or any other cell you type:

=INDIRECT(B1) it will equal "5".

I hope I helped yo