Excel Forum
Similar Content
Using Formulas with Tables in Excel
Tutorial: Easy way to reference data tables and make formulas within a data table. This allows you ...
Create and Manage Tables in Excel
Tutorial: Here, I'll show you everything you need to know to get started using tables in Excel; how...
HLOOKUP in Excel
Tutorial: The Hlookup function allows you to scan a row from left to right in search of a value and ...

Excel Name Trick #10: Store Lookup Tables in Memory

See how to store Lookup Tables in memory using a named array. See how to use a named array in a VLOOKUP function. Then the table won't waste space in the spreadsheet.

See the syntax for an array stored in a name: comma is for column, semi-colon is for row, curly brackets house the array, and Quotes hold text.

See how to use a named array in a VLOOKUP function.

This is a logical (beginning to end) story about most of the use for Excel Names. In this series you will see 12 amazing uses for Excel Names (14 total Name Tricks).

Got a Question? Ask it Here in the Forum.