Named Range as reference in a formula

		Microsoft Office Forums > Microsoft Excel > Excel
Named Range as reference in a formula

03-27-2024, 03:07 PM

Marcia

Windows 11 Named Range as reference in a formula

Office 2021

Expert

Join Date: May 2018

Location: Philippines

Posts: 553

Quote:

Originally Posted by p45cal

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mail Merge with Excel Named Range	Rocki	Mail Merge	1	01-10-2020 02:06 PM
How to reference a named range in a different file within a formula	Brock297	Excel	1	10-25-2018 08:50 AM
Define a spreadsheet range using two named variables	persist	Excel	2	05-13-2014 10:56 PM
Excel - move with tab through named range	mjlaw	Excel	4	03-26-2012 10:40 AM
Named range drop-down	jgelpi16	Excel	1	04-08-2011 03:08 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:14 AM.