Hi there,
I'm trying to combine text and a cell reference using Indirect.
Cell B1 contains the text "Region" (no quotation marks)
In another cell I'm trying to create a reference to "Region total" (no quotation marks)
By my limited understanding the below should work
=INDIRECT("b1"&" total")
But the cell returns #REF!. I've tried pretty much every combination of quotation marks around different elements of the formula I can think of.
Cell B1 is a drop down list, don't imagine that's relevant, but it may be.
Any help much appreciated.
Bookmarks