lookup on named formula
 

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
------------------------------------------------------------------------
ViMuTo's Profile: http://www.excelforum.com/member.php...o&userid=32125
View this thread: http://www.excelforum.com/showthread...hreadid=520138

lookup on named formula
 

Ooops. Accidentally duplicated. Sorry!


--
ViMuTo
------------------------------------------------------------------------
ViMuTo's Profile: http://www.excelforum.com/member.php...o&userid=32125
View this thread: http://www.excelforum.com/showthread...hreadid=520138

lookup on named formula
 

You can use evaluate(), but not directly. Here is an example:
http://www.ozgrid.com/News/excel-eva...ormula-VBA.htm
--
It is nice to be important, but it is more important to be nice


"ViMuTo" wrote:


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
------------------------------------------------------------------------
ViMuTo's Profile: http://www.excelforum.com/member.php...o&userid=32125
View this thread: http://www.excelforum.com/showthread...hreadid=520138

lookup on named formula
 

Assuming your data looks like this:
The constants a
An Bn
8 2
The four named operation formulas a
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)

lookup on named formula
 

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!!!


--
ViMuTo
------------------------------------------------------------------------
ViMuTo's Profile: http://www.excelforum.com/member.php...o&userid=32125
View this thread: http://www.excelforum.com/showthread...hreadid=520138