Hi!
noob here
I want to have a cell to refer to another one but to take the row number from a cell which I will type the number.
example : Let's say that I have A1 and A2 cells filled
and cell C1=A(B1 TYPED NUMBER)
So when I type in B1 cell the numer 1, C1=A1,
and when I type in B1 cell the numer 2, C1=A1,
So how can I do it?
I used c1=a($b1) , but it didn't worked.
Bookmarks