Relative Referencing

[sungsy]

Hi we use $ to make either row or column absolute reference in a cell. However I want to force a relative referencing of a column across row. Let me try to explain. when A$1 is move to next cell to the right it --> b$1. Is there a way to make it b$1 when the cell is move 1 row down? Thank for you help and look forward the response

 

[Andrew Poulsom]

Try eg:

=INDEX($1:$1,1,ROW(A1)-ROW(A$1)+1)