From: Raj on
For a vlookup function, I need to reference a name in another
workbook,
If the workbook is "Source Data.xls" and the Defined name in that
workbook is "lookuprange" then what will the second argument in the
formula below (in another workbook) be

=vlookup(b2,second argument,3,false)

Thanks in Advance for the help.

Regards,
Raj

From: JLGWhiz on
See if this site helps:

http://www.contextures.com/xlFunctions05.html#RefWkbk



"Raj" <rspai9(a)gmail.com> wrote in message
news:d8a6f9e7-2a12-4ede-8615-fdec3a46807c(a)34g2000prs.googlegroups.com...
> For a vlookup function, I need to reference a name in another
> workbook,
> If the workbook is "Source Data.xls" and the Defined name in that
> workbook is "lookuprange" then what will the second argument in the
> formula below (in another workbook) be
>
> =vlookup(b2,second argument,3,false)
>
> Thanks in Advance for the help.
>
> Regards,
> Raj
>


From: Peter T on
=vlookup(b2,'Source Data.xls'lookuprange,3,false)

note the apostrophes

Regards,
Peter T

"Raj" <rspai9(a)gmail.com> wrote in message
news:d8a6f9e7-2a12-4ede-8615-fdec3a46807c(a)34g2000prs.googlegroups.com...
> For a vlookup function, I need to reference a name in another
> workbook,
> If the workbook is "Source Data.xls" and the Defined name in that
> workbook is "lookuprange" then what will the second argument in the
> formula below (in another workbook) be
>
> =vlookup(b2,second argument,3,false)
>
> Thanks in Advance for the help.
>
> Regards,
> Raj
>