View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
zim zim is offline
external usenet poster
 
Posts: 9
Default 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