Forum Discussion
Solved
A$1 working as $A$1 instead of B$1, C$1, etc.
Hi all, I am working on a spreadsheet for work and seem to be running into the same issue over and over again. I am wanting to reference a row in a formula for a column, however when I try to drag th...
=INDEX(Sheet!$5:$5,,ROW(A7))This works in my file if i correctly understand what you want to do.
=INDEX(Sheet!$5:$5,,ROW(A7))This works in my file if i correctly understand what you want to do.
That got it working! Thanks so much for the help!! You would think referencing rows in columns and vice versa wouldn't be so difficult!