Index Function

[Karl]

Hi,

I need to set up an index function that not only reads in
the row and column numbers but also the range name

e.g.

Index(B1,B2,B3)

where

B1 contains the range name
B2 contains the row number
B3 contains the column number

I have no trouble pulling in the row and column number
from B2 and B3, but can't get it to work when I try to
pull in the range name in B1.

Any help would be appreciated.

 

[Thomas]

If your range name is in B1 use:
INDEX(INDIRECT(B1),B2,B3)

 

[Karl]

Thanks Thomas.

It works like a charm.

-----Original Message-----
If your range name is in B1 use:
INDEX(INDIRECT(B1),B2,B3)

.