Hi, thank you for your quick response. I have four 4x10 tables where 3
coefficients are interpolated from. My list selection will determine
which set-of-3 coefficients to use. These coefficients along with other
calculations will then be used to solved for an answer (A). Answer (A)
can be solved without much effort. However, if I need to use answer (A)
derived from other input parameters, then I will either have to give up
the initial inputs, or create duplicate but similar procedure. I used
vlookup, index, match, etc. to lookup the table values, and I can
essentially create a duplicate of the procedure. But, it's Cumbersome.
My goal is to try to keep the sheet as lean as possible so it's easy to
track in the future. But I guess the only way to do it is through VB,
otherwise I'm afraid most programming language would be put out of
business.

All I know about Yogi Berra is that he was a great American baseball
player.
Thank you very much for your advice. This is a great place to look for
solution, I might just stumble upon it someday.


--
csw78
------------------------------------------------------------------------
csw78's Profile: http://www.excelforum.com/member.php...o&userid=23008
View this thread: http://www.excelforum.com/showthread...hreadid=374134