Dyanamic passing of formula parameters

I am trying to create a nested If statement involving 9 if values. Instead of creating one gigantic formula involving all of the if, thens I would like to have and if statement that redirects to another cell containing the related formula (like a function section for C++). I would like to be able to pass variables to this formula cell that would change depending on the cell location of the original if formula. In other words I would like to pass some global variables to a related cell which contains a formula using those variables.

example:

IF (A1 = x, go to cell AZ1, if A1 = y, go to cell AZ2, etc.)

AZ1 and AZ2 would compute a formula using values related to A1. But these values would change when A2 is used in the if statement.

Take at look at INDIRECT in Excel help.

i dont think you are explaining the problem properly because the way i read it you answer should be:

IF (A1 = x, AZ1, if A1 = y, AZ2,"") ,"")

and then in AZ1 and AZ2 you can have other logic formulas doing the calculation. Clearly either i am reading the problem wrong or you have explained it wrong because that answer is wayyyyy to obvious