hi, !

try with: =sum(indirect(cell 1) indirect(cell 2))

hth,
hector.

__ original post __
I've got one sheet with named rows & columns. For example row4 is a named range "Area4"
and column C is a named range "Beans".
On a seperate worksheet if I type in; =Area4 Beans
then I get the intersecting number of beans but if i have two cell with
Cell 1 - Area4
Cell 2 - Beans
and type in another cell; =Indirect(Cell 1 & " " & Cell 2)
all I get is the corresponding value from Area4 that matches the column I typed the Indirect function into
instead of column C ("Beans") on the other worksheet.

Any Help would be great!