I have several Named formulas: P6Term6, P6Term5....., P5Term5, P5Term4... ...)
And a Cell (using a validation list) with numbers 1-6 (I want this number to be used to call the right formulas (P#Term6, P#Term5, and so on), where # is the value in the cell (named "Power")
When I call the named ranges manually in a cell (i.e. =P6Term6) it works fine.
My trouble is trying to make it so I can use the cell to change the one number.
I am using the following formula:
I am getting a #REF error, although when I evaluate the formula it seems good utill the end. I am just learning named ranges and INDIRECT so I do not have much expierience in this. Any help would be appreciated.
Thanks
Mark
Bookmarks