mochalatte
New Member
- Joined
- Feb 12, 2021
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
I would like to capture the first 20 rows of the range described in the formula I have OFFSET('Market Returns'!$J$3:$O$249,0,L$1-1). I tried using index but I am getting reference errors. Thank you. The formula works otherwise.