How do you specify a named range from a particular sheet?

  • Thread starter Thread starter Toby Erkson
  • Start date Start date
T

Toby Erkson

I have one workbook that is supposed to pull info from another. The other
workbook has a named range on one of its sheets. Here is my formula:
=IF(VLOOKUP($A63,'Client summary
report.xls'!Volumes,8,FALSE)<1,"0",VLOOKUP($A63,'Client summary
report.xls'!Volumes,8,FALSE))

Volumes is the named range and it's on the sheet named Raw_Data.rpt (I
didn't name the sheet, BTW). The only thing I'm getting returned is a #REF!
error :-(

Thanks,
 
Nevermind, I figured it out:
=IF(VLOOKUP($A63,'[Client summary
report.xls]Raw_Data.rpt'!Volumes,8,FALSE)<1,"0",VLOOKUP($A63,'[Client
summary report.xls]Raw_Data.rpt'!Volumes,8,FALSE))

Just had to get the location of the []!' in the right order <rolleyes>
 
You can also define a named range in your destination workbook that refers
to the source workbook.
'c:\yourfolder\sourcefile.xls'!definednameinsourceworkbook
or
'c:\yourfolder\[sourfile.xls]sheet1'!$a$1:$z$21

Make sure of the ' and their placement.

--
Don Guillett
SalesAid Software
(e-mail address removed)
Toby Erkson said:
Nevermind, I figured it out:
=IF(VLOOKUP($A63,'[Client summary
report.xls]Raw_Data.rpt'!Volumes,8,FALSE)<1,"0",VLOOKUP($A63,'[Client
summary report.xls]Raw_Data.rpt'!Volumes,8,FALSE))

Just had to get the location of the []!' in the right order <rolleyes>
--
Toby Erkson
Oregon, USA
WindowsXP, Excel 2003

Toby Erkson said:
I have one workbook that is supposed to pull info from another. The other
workbook has a named range on one of its sheets. Here is my formula:
=IF(VLOOKUP($A63,'Client summary
report.xls'!Volumes,8,FALSE)<1,"0",VLOOKUP($A63,'Client summary
report.xls'!Volumes,8,FALSE))

Volumes is the named range and it's on the sheet named Raw_Data.rpt (I
didn't name the sheet, BTW). The only thing I'm getting returned is a #REF!
error :-(

Thanks,
Click to expand...
Click to expand...
 
glad to help

--
Don Guillett
SalesAid Software
(e-mail address removed)
Toby Erkson said:
Ah, good info...thanks!
Toby

Don Guillett said:
You can also define a named range in your destination workbook that refers
to the source workbook.
'c:\yourfolder\sourcefile.xls'!definednameinsourceworkbook
or
'c:\yourfolder\[sourfile.xls]sheet1'!$a$1:$z$21

Make sure of the ' and their placement.
Click to expand...
Click to expand...
 
Back
Top