I think I'd use a macro that created those formulas on another worksheet.

Then use =vlookup() against that helper sheet.

Or make sure that other workbook is open???

darsg wrote:

is there any other function which would help with closed work books.....

"Dave Peterson" wrote:

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


--

Dave Peterson