Excel Forum



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.