Edit a Name
wanted to add or modify one of your Names. You can use the Name
Manager to edit the name and the range. You can also add a comment
to document your changes if you wish.
This: Create or Edit a Name
Go to Formulas->Defined Names->Name Manager.
Click on New.
The New Name window will open.
Enter a Name: Product
Enter the Scope: Workbook
Click on Lookup (the red, white and blue
Go to the Original Data spreadsheet.
Select Cells B1 through B58.
Lookup to return New Name
Click on OK to return to the Name Manager.
added another Defined Name to the