lookup on named formula

[ViMuTo]

I have 2 columns:
col A contains unique codes
col B contains the names of named formulas

TTT name1
TTF name2
TFT name3
TFF name4

Is there a way to do a lookup or index/match or whatever to find the
appropriate code in column A and perform the corresponding named
formula in column B?

 

[ViMuTo]

Ooops. Accidentally duplicated. Sorry!

 

[Guest]

You can use evaluate(), but not directly. Here is an example:
http://www.ozgrid.com/News/excel-evaluate-formula-VBA.htm

 

[Herbert Seidenberg]

Assuming your data looks like this:
The constants are:
An Bn
8 2
The four named operation formulas are:
Op1 Op2 Op3 Op4
=An*Bn =An/Bn =An+Bn =An-Bn
16 4 10 6

Here is the lookup table with headers:
code op_name
TTT op1
TTF op2
TFT op3
TFF op4

Here is the user interface:
input output
TFF 6

Type in the code you are searching into the input cell.
The output cell formula is:
=CHOOSE(MATCH(input,code,0),Op1,Op2,Op3,Op4)

 

[ViMuTo]

Miguel and Herbert, thank you very much for your suggestions!

In this situation, I believe the information that Herbert provided is
going to work out in the way that I need it to. Thank you very much for
your wonderfully clear instructions! I greatly appreciate it!!!