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!

Thanks,
Ryan