Thread: [Solved] Named Range as reference in a formula
View Single Post
 
Old 03-27-2024, 03:07 PM
Marcia's Avatar
Marcia Marcia is offline Windows 11 Office 2021
Expert
  
Join Date: May 2018
Location: Philippines
Posts: 527
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default
Quote:
Originally Posted by p45cal View Post
I was going to offer the same solution as xor, although if you want to copy down it might work better with INDIRECT($K$2) instead of INDIRECT(K2)
Yes, I locked the reference. Thank you.
Reply With Quote