I have a Named Range named Car. In another tab, I have:

A16 reproduces the header of the Named Range:


A17 lists out the values in the Named Range:


If I ever change the name of the Named Range, I'd like to avoid having to manually update the formula in A17. That way, I only have to update the Range name and the header in the other tab (Categories!C1).

Is there a way to use the FILTER formula, but instead of referencing the Named Range, I pull from the value in A16? Something like:

=FILTER(Range matching A16,NOT(ISBLANK(Range matching A16)))

I know that's not right, but I'm not sure if there is in fact a feature to pull this off. Any insight would be much appreciated!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.