|
Featured Tutorial
Featured Macro
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).
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).