Combining 2 cells to create a formula

[mark1960]

I need to combine the contents of 2 cells into a formula that will return the value of a named cell, eg

I have a cell named - "ees007"

Cell A1 = ees
Cell B1 = 007

I need a formula which will combine A1 and B1 to return the value of cell "ees007"

I'm sure there's a simple solution but I'm obviously too simple to find it!

Thanks
Mark

 

[VoG]

Try

=INDIRECT(A1&B1)

 

[mark1960]

Thanks VoG, just what I needed.

Mark