Hi all,
I was wondering if somebody can help.
I have a dynamic name called "crap"
In cell A1 i have the string "crap-2"
This cell will vary and look up a different table.
I have tried the formula = sum(indirect(left(A1,4)) but this returns a #ref error.
I have had a quick invistigation and if crap referred to a static range, the function above works. So, is there any way i can make this work with a dynamic range in a name?
Thanks
Bolo
P.S. I am using XL2K
I was wondering if somebody can help.
I have a dynamic name called "crap"
In cell A1 i have the string "crap-2"
This cell will vary and look up a different table.
I have tried the formula = sum(indirect(left(A1,4)) but this returns a #ref error.
I have had a quick invistigation and if crap referred to a static range, the function above works. So, is there any way i can make this work with a dynamic range in a name?
Thanks
Bolo
P.S. I am using XL2K