Universal Name Ranges

AFlint

I'm looking for an option to create a universal name range that I can use across all sheets.

I have created a sheet that contains the following columns

Team / Office / Division

I use this to translate reports that only contain Team info into Office and Division level reports by using a =VLOOKUP. However, every time I need to use this table in a new sheet, I have to recreate the same vlookup manually. What I would like to be able to do is have a perpetual name like {Office Lookup} that I could just type into any formula that needs to reference this table. Then, I would just adjust the lookup based on column number depending on whether I want the Office or Division.

If this is available in a certain add-on level, please let me know. I am currently on Enterprise.

Thank you

Andrée Starå

Hi @AFlint

I hope you're well and safe!

Unfortunately, it's not possible now, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

Here's a possible workaround or workarounds

• Create a template that is connected to the Universal Sheet and Save it as new to include the cross-sheet reference

Would that work/help?

I hope that helps!

Be safe and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @AFlint

I hope you're well and safe!

Unfortunately, it's not possible now, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

Here's a possible workaround or workarounds

• Create a template that is connected to the Universal Sheet and Save it as new to include the cross-sheet reference

Would that work/help?

I hope that helps!

Be safe and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

AFlint

Hi @Andrée Starå

Thanks for the response. I was pretty sure that no tool currently existed, but I had to ask ;-)

The template idea is a good one, but unfortunately, I build most of the sheets that would use this lookup from a spreadsheet import so it matches the source and is easier to set up in Data Shuttle.

I'll definitely submit the enhancement request now that I know it is not an existing feature.

Andrée Starå

@AFlint

Excellent!

Happy to help!