KG,

'Book 1.xls'!GrossSales

For example:
=SUM('Book 1.xls'!GrossSales)
=VLOOKUP(A2, 'Book 1.xls'!GrossSales, 2)

Note that a Range name cannot have a space, hence GrossSales, not Gross
Sales.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"KG" wrote in message
...
Workbook #1 has a range named "Gross Sales" in Sheet1 Cells A2:K2. How can
I
point to this range so that I can link it to Sheet1 Cells2:K2 in Workbook
#2?