I have the below entry when i go to the insert > name > Define name
what does it mean ?
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.