Universal Name Ranges


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

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!