Am new to spread sheets, so I hope I explain my question clearly.
1/ I have two columns side by side.
2/ The left column’s cells contain data that will be processed by a formula cell directly to the right of each left cell.
3/ I would like the right column’s formula cell to process the left cell without having to have reference the left cell by row and column address. In this way, I can repeat the formula down the right col, and not have to update each instance of the formula with the row and col address of the column to the left of it.
Thanks in advance for any advice.
(Slightly edited by @Lupp for better readability.)