Referencing Defined Name in another workbook

R

Raj

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
 
P

Peter T

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

note the apostrophes

Regards,
Peter T
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

populate a combobox based on unique values in another workbook 16
Calling subroutine defined in another workbook (autostart workbook) 5
Hotkey in proper workbook 2
Reference to a Defined Name in another Workbook 1
copying to new workbook 0
Reference workbook with a certain word in the name 1
Macro code for clicking on Command Button in another workbook 7
VBA to copy from one workbook into another 0

Top