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

See if this site helps:

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



"Raj" wrote in message
...
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

=vlookup(b2,'Source Data.xls'lookuprange,3,false)

note the apostrophes

Regards,
Peter T

"Raj" wrote in message
...
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