Thread: Accessing named cell using a string

Hi

If I have a cell which I have named "ZY", I would like to access this by building a string from row and column headings and then accessing the relevant cell. For example,

If A2 contains "Z" and C1 contains "Y"

I would like to say "=A2&C1" which, as you would expect returns "ZY".

But how can I use this string to access the value stored in the cell NAMED ZY.

I have been playing around with INDIRECT, CELL etc. but just can't see how to do it.

Can it be done?

Thx

G

Thank you. I think I still has some issues with accessing cells across different sheets - but this has put me on the right lines.

Thx again.

G