Take the 2-minute tour ×

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
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
add comment

migrated from stackoverflow.com Nov 12 '09 at 22:59

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

2 Answers

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
add comment

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
add comment

Your Answer

