View Single Post
  #8   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default

On Thu, 26 May 2005 21:07:32 GMT, "John Galt"
wrote:

Thanks.
The 2nd formula worked out better for me.
I made the necessary adjustments and voila!
I appreciate your help!


Glad to help.

Be sure your years are sorted in ascending order or the MATCH function may not
find the correct one. Also, any YEAR higher than the highest one in the table
will return the last value.

Thanks for the feedback.
--ron