Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have the below entry when I go to the Insert > Name > Define name

='Lookup Tables'!$I$29:$I$65

What does it mean?

share|improve this question

migrated from Nov 12 '09 at 22:59

This question came from our site for professional and enthusiast programmers.

im assuming it refers to column I row's number 29-65, but of what I am not sure. – Anthony Forloney Nov 12 '09 at 15:26

It is called a named Range. The name of which can be found in the Insert>Name>Define Dialog.

Lookup Tables is the name of a Sheet. The Range on that sheet is I29-I65.

This construct can be used, for example, when reading an Excel spreadsheet using ADO. You would reference the range in the SQL select statement "Select * from NamedRange.

share|improve this answer
sheet means workbook? there are so many tabs (workbooks) in my excel ,,, which workbook i have to check? – SmartestVEGA Nov 12 '09 at 15:27
To add to this, the $ symbol by the letter and the numbers ensure that if you copy the formual that it does not iterate the columns or row numbers. – lansinwd Nov 12 '09 at 15:28
i couldnt see any data in the range that you specified ... !! – SmartestVEGA Nov 12 '09 at 15:34
A workbook is the equivalent of a file. Each tab is a worksheet within the workbook. – guitarthrower Nov 12 '09 at 16:56
The data is on the Sheet (tab) named 'Lookup Tables'. – littlegreen Nov 12 '09 at 22:17

You can place a “lookup table” on a worksheet and Excel can retrieve data from it from a location on the same worksheet, or in the same workbook, or even from another workbook.

This means, for example, that lookup functions on an invoice worksheet can handle the details of putting the unit price in the right place. When prices change, they only need to be changed in the lookup table, not in every individual invoice that is written.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.