Quote:
Originally Posted by Claus Busch
Hi,
Am Thu, 11 Aug 2016 17:01:56 +0100 schrieb alphanull:
Is there a way to combine IF and LOOKUP
The spreadsheet layout
Column A Year - the date of the deposit affected
Column B Deposit reported
Column C Deposit allowed
Column D Ineligible amount - this amount is multiplied by the
multiplier
Column E Multiplier
Column F Ineligible deposit amount to be returned
try for the multiplier:
=HLOOKUP(A11,$L$2:$O$3,2,0)
Regards
Claus B.
--
Windows10
Office 2016
|
Claus,
Thanks for the suggestion, this works.
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.