| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Concatenate RangeName for INDEX?
Hi All.......
I am trying to Concatenate a RangeName being used in an INDEX formula. J1=DEFECTS, D5=30220 =INDEX(J1&D5,3,4) don't seem to work. If I type in =INDEX(DEFECTS30220,3,4) it works fine.... I would like to pull the RangeName out of the formula hard coding if possible. Any help would be appreciated. Vaya con Dios, Chuck, CABGx3 |
|
#2
|
|||
|
|||
|
Have a look in HELP index for INDIRECT which cannot be used to get info from
a closed workbook. -- Don Guillett SalesAid Software "CLR" wrote in message ... Hi All....... I am trying to Concatenate a RangeName being used in an INDEX formula. J1=DEFECTS, D5=30220 =INDEX(J1&D5,3,4) don't seem to work. If I type in =INDEX(DEFECTS30220,3,4) it works fine.... I would like to pull the RangeName out of the formula hard coding if possible. Any help would be appreciated. Vaya con Dios, Chuck, CABGx3 |
|
#3
|
|||
|
|||
|
Chuck, just put INDIRECT around it;
=index(indirect(j1&d5),3,4) "CLR" wrote in message ... Hi All....... I am trying to Concatenate a RangeName being used in an INDEX formula. J1=DEFECTS, D5=30220 =INDEX(J1&D5,3,4) don't seem to work. If I type in =INDEX(DEFECTS30220,3,4) it works fine.... I would like to pull the RangeName out of the formula hard coding if possible. Any help would be appreciated. Vaya con Dios, Chuck, CABGx3 |
|
#4
|
|||
|
|||
|
Thanks for the lead Don......
Vaya con Dios, Chuck, CABGx3 "Don Guillett" wrote: Have a look in HELP index for INDIRECT which cannot be used to get info from a closed workbook. -- Don Guillett SalesAid Software "CLR" wrote in message ... Hi All....... I am trying to Concatenate a RangeName being used in an INDEX formula. J1=DEFECTS, D5=30220 =INDEX(J1&D5,3,4) don't seem to work. If I type in =INDEX(DEFECTS30220,3,4) it works fine.... I would like to pull the RangeName out of the formula hard coding if possible. Any help would be appreciated. Vaya con Dios, Chuck, CABGx3 |
|
#5
|
|||
|
|||
|
Thank you kind Sir.......I have been fooling with that for over an
hour......it's so easy when you know how...... Vaya con Dios, Chuck, CABGx3 "Dave R." wrote: Chuck, just put INDIRECT around it; =index(indirect(j1&d5),3,4) "CLR" wrote in message ... Hi All....... I am trying to Concatenate a RangeName being used in an INDEX formula. J1=DEFECTS, D5=30220 =INDEX(J1&D5,3,4) don't seem to work. If I type in =INDEX(DEFECTS30220,3,4) it works fine.... I would like to pull the RangeName out of the formula hard coding if possible. Any help would be appreciated. Vaya con Dios, Chuck, CABGx3 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) | |||
| UDF to evaluate result of concatenate() with additional arg. | Excel Discussion (Misc queries) | |||
| Concatenate cells without specifying/writing cell address individually | Excel Discussion (Misc queries) | |||
| Concatenate two halves of a phone number | Excel Worksheet Functions | |||
| How to Concatenate Time with some operator? | Excel Worksheet Functions | |||
Linear Mode
