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,

--
Toby Erkson
Oregon, USA
WindowsXP, Excel 2003

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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,
>
> --
> Toby Erkson
> Oregon, USA
> WindowsXP, Excel 2003
>
>

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 Removed)
"Toby Erkson" <(E-Mail Removed)> wrote in message
news:eEgq$(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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,
> >
> > --
> > Toby Erkson
> > Oregon, USA
> > WindowsXP, Excel 2003
> >
> >
>
>

Ah, good info...thanks!
Toby

"Don Guillett" <(E-Mail Removed)> wrote in message
news:OQbm$(E-Mail Removed)...
> 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...

glad to help

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Toby Erkson" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Ah, good info...thanks!
> Toby
>
> "Don Guillett" <(E-Mail Removed)> wrote in message
> news:OQbm$(E-Mail Removed)...
> > 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...
>
>