| 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. |
| 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) | |||
Threaded Mode
