Originally Posted by Claus Busch

Hi,

Am Thu, 11 Aug 2016 20:38:16 +0100 schrieb alphanull:

The one problem I am having is, how do I deal with:
if my year is less than 2014 = .064, we have deposits that are prior to
the 2014 year. All years 2014 back are 0.064 while 2015 forward change.

try:
=HLOOKUP(MAX(A11,2014),$L$2:$O$3,2,0)


Regards
Claus B.
--
Windows10
Office 2016