concatinate and vlookup
Use the INDIRECT() function
Look in HELP for details
--
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.
|