kubazabran
New Member
- Joined
- Feb 22, 2022
- Messages
- 13
- Office Version
- 365
- Platform
- MacOS
- Web
Hi,
is it possible to do something like this? I have a reference to the source sheet from different sheet and I'd like to retrieve data from a column that is always 12 cols left. E. g.:
A | B
=src_data!O3 | =srcdata!(O3-12) - this would get the value of C3 in the srcdata
When I change the col in column A, the formula in B would get again -12 col from the source file.
I experimented with some formulas but I wasn't able to get the answer. Thanks!
is it possible to do something like this? I have a reference to the source sheet from different sheet and I'd like to retrieve data from a column that is always 12 cols left. E. g.:
A | B
=src_data!O3 | =srcdata!(O3-12) - this would get the value of C3 in the srcdata
When I change the col in column A, the formula in B would get again -12 col from the source file.
I experimented with some formulas but I wasn't able to get the answer. Thanks!