View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Raj[_2_] Raj[_2_] is offline
external usenet poster
 
Posts: 150
Default Referencing Defined Name in another workbook

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