Assuming I'm reading this correctly, you could probably make a new
named range that references the old one.
UptoFeb2 =personal.xls!uptofeb
then use =Vlookup(a1,uptofeb2,12,false)

On Mar 29, 4:27 pm, "mithu" wrote:
I have a list that has the monthly revenue for 300 companies.

what i have done is put these in my personal.xls file. and setup a
range name for them.

so if i ever need to pull these numbers from any spreadsheet i can get
them by typing

=vlookup(a2,personal.xls!uptofeb,12,false)

this gets me the revenue for whichever id is in a2 and pulls data from
column 12 in personal.xls ..

is there anyway i can get it so that i only have to put the range name
in the target array.

so i only have to put.. =vlookup(a1,uptofeb,12,false) and it pulls
the data from personal.xls by it self?