The bad news is that =indirect() won't work with closed workbooks.



darsg wrote:

hi,
is it possible to use concatinate function in vlookup
my formula is like,
=vlookup(c2,'m:/test.xls'!dstran,5)
what i want is in this formula dstran is a defined range in test file
i want to use concatenate function for this defined name
i want
=vlookup(c2,'m:.test.xls'!concatenate(d2,"tran"),5 )

because d2 keep changing for me

please help me asap!!!

i will be very helpful.

--

Dave Peterson