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