tried is not workin any suggestion
thanks

"Niek Otten" wrote:

Didn' test, bur try this:

=vlookup(c2,INDIRECT("m:.test.xls!"&d2),"tran",5)

--
Kind regards,

Niek Otten


"darsg" wrote in message
...
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.