'Cell referencing using just numbers
I have a formula:
=LET(Data,'Sheet1'!G9:Y19, .....)
I really would like to reference Y19 using numbers, kind of like
=LET(Data,'Sheet1'!G9:Column(25)19, .....)
if that makes sense. Since this cell reference changes and needs to be dynamic. How can I achieve this? Could I just remake a formula in VBA that does this? If so, how?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|