Using Named Formulas in Indirect

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:

Please Login or Register  to view this content.

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

Thank you both for rplying so quickly

NBVC, originally, I assumed that I needed to pass it through a text, rather than a number. But, i also tried it the way you stated and it didn't work that way either.

Andy, When I put "=Power" in a cell, it works fine and returns "6".

I have posted the workbook, I hope you can follow it, it is still a work in progess, therefore a little messy. (I have colored the particular cells that I am working on with red)

Thanks again,
Mark

I guess I don't understand why, if I can put =P6Term6 in a cell and it works, then why can't I have a formula concatenate that "P6Term6" and have transfer into a cell.

Thank you for your help anyway, I appreciate your time and effort.

Mark

I have been racking my brain trying to get this because as I watch it in the formula evaluater, it does indeed (in the steep just before the #REF) given an output of "P6Term6" and , like I said, If I simple put "P6Term6" in the formula, it works just fine.

I guess, Im just stuck with it. Maybe someone else will speak up with an answer.

thanks again