In Excel, how do I make a lookup table that returns a function
John,
That works most excellently! I used the Select Case statement, as you
sketched above. The only issue now is that the function does not reevaluate
itself when the argument cells change, until I click on the function in the
editing bar and press enter. Any hints?
--zim
|