Hello all,

I am back with yet another question.
This time I am trying to get a cell to obtain a formula depending on another cell...here's the example and my attempt.

Cell A1... ="FA"
 Cell A2... =IF(A$1<>"",VLOOKUP(LEN(A$1),$B$1:$C$6,2,FALSE),"")
I want A2 to generate a formula based on the number or characters in cell A1, since this example results in 2 characters, I want to lookup the formula in the table associated to 2. However, this example just returns the value of the cell instead of the formula in the table. Is there a way to return a formula instead? I am manually updating the formulas everytime I need now, but would be tons easier if it was automated.

Thanks!
I can post a example spreadsheet if necessary.