Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatinate name and date | Excel Discussion (Misc queries) | |||
Concatinate Formatting | Excel Discussion (Misc queries) | |||
Concatinate a function and make it work | Excel Discussion (Misc queries) | |||
concatinate data | Excel Worksheet Functions | |||
Concatinate a filename | Excel Discussion (Misc queries) |