Hi folks
I have two spreadsheets. The sourse spreadsheet already has many named ranges which i would like to use for the main spreadsheet to pick up its information. Is there an easy way when using vlookup or the like to name the range in the other spreadsheet?
thanks guys
James
Use Named Range From Another Workbook in Formula
-
-
-
Re: Link to range in another spreadsheet
Hi,
Are you looking to refer to the named range in the source sheet, as in =Sourcesheet!MyName, or are you wanting to name the ranges in your main sheet to match those in your source sheet?
Rico.
-
Re: Link to range in another spreadsheet
Hi rico,
Yeah sorry i didn't really expalin that very well...for example...the sourse sheet has named ranges like "a784a" and i want to put in my vlookup formula in the main spreadsheet vlookup(a2,a784a,2,0) but it wont recognise the a784a. Do i need to go vlookup(A2,[sourceworkbook]a784a,2,0)...or something like that?..I just want to avoid having to manually select all the ranges again?
thanks Rico
James -
Re: Link to range in another spreadsheet
Hi,
You can do it one of two ways. If you're typing it just use =vlookup(A2,Sourceworkbook!a784a,2,false). Or you can simply use the function wizard and select the named range - excel should recognise the range as its name rather than its range.
Rico.
-
Re: Link to range in another spreadsheet
Thanks Rico...much appreciated
-
-
Re: Link to range in another spreadsheet
Details here on VLOOKUP
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!