concatinate and vlookup
 

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.

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.

concatinate and vlookup
 

can you please help me i can not make a formula , how does my formula look
like using indirect function..

thanks


"Niek Otten" wrote:

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.

concatinate and vlookup
 

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.

concatinate and vlookup
 

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

concatinate and vlookup
 

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

concatinate and vlookup
 

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.

concatinate and vlookup
 

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