Thread
:
Concatenate RangeName for INDEX?
View Single Post
#
4
CLR
Posts: n/a
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
Reply With Quote