Prev: using VLOOKUP in a text box
Next: Parsing thru columns to find the last number
From: Raj on 5 May 2010 12:00
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 5 May 2010 12:30
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 5 May 2010 13:28
=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
>


 | 
Pages: 1
Prev: using VLOOKUP in a text box
Next: Parsing thru columns to find the last number