Create names to use in Microsoft Excel Functions

When you create a name for a group of cells it’s called Naming Ranges this is useful to make navigating workbooks more efficient. You can use the Microsoft Excel feature of creating Ranges Names to include in functions. What this does is make a lengthy function much more user friendly by making it easier to read. Take for example a Vlookup which is a popular function that matches data from one list to another then returns specified data from a column in the Master list.

Instead of reading: = Vlookup(A6,StockList!$A$1:$F$300,4,False)

In place of the table item you can use a Range Name like ProductList, notice there is no space in the Name, that’s important you can read more about Range Names Click here.  

Vlookup(A6,ProductList,2,False) or = Sum(SalesTotals).

Another idea where you can use Range Names is in Data Validation Lists,  or to make it easer to print reports you could create a Range Name that selects the area to be printed.

STEPS to creating a very simple Range Name are:- Select your data, then go to the Name Box (top left hand corder) and type the name you would like to give your Range Name, remember there are rules. Pressing Enter after naming your Range Name correctly is critical.

AZ Solutions Pty Ltd Offers Customized Computer Training Courses in Sydney – Australia “We come to you”.

Servicing Our Customers since 1999 – Hino, Toyota, Taren Point Hotel, Civic, Caltex Refineries, Sutherland Shire Care Support Service….

Free Tutorials | YouTube Channel – Analir Pisani

Visit website reviews



Related Topics

Creating Names for Data Validation List

How to show all Formulas in Excel

How to create a Vlookup function in Excel

Vlookup not working?

Naming cells in Excel


About Customised Computer Courses Sydney - Sutherland Shire M 0414 417 059

On-Site customised computer training courses Sydney - Sutherland Shire. Excel, Word,Power Point, Access, Outlook, Visio, Publisher, Excel VBA e: m: 0414 417 059
This entry was posted in Excel. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s