I am trying to work with the attached formula but keep getting NA
The principle of the formula checks out so I can only assume I am inputting it wrong
Anyone any ideas?
=(IF($L23>1,-ParametersAFP!$K$68*VLOOKUP($B23-2,$B$7:$HL$133,215,0),0))
+(IF($K23>1,-ParametersAFP!$K$66*VLOOKUP($B23-20,$B$7:$HL$133,215,0),0))
+(IF($J23>1,-ParametersAFP!$K$63*VLOOKUP($B23-200,$B$7:$HL$133,215,0),0))
+(IF($I23>1,-ParametersAFP!$K$59*VLOOKUP($B23-2000,$B$7:$HL$133,215,0),0))
+(IF($L23+$k23>1,-ParametersAFP!$K$67*VLOOKUP($B23-11,$B$7:$HL$133,215,0),0))
+(IF($L23+$j23>1,-ParametersAFP!$K$65*VLOOKUP($B23-101,$B$7:$HL$133,215,0),0))
+(IF($j23+$k23>1,-ParametersAFP!$K$64*VLOOKUP($B23-110,$B$7:$HL$133,215,0),0))
+(IF($i23+$l23>1,-ParametersAFP!$K$62*VLOOKUP($B23-1001,$B$7:$HL$133,215,0),0))
+(IF($i23+$k23>1,-ParametersAFP!$K$61*VLOOKUP($B23-1010,$B$7:$HL$133,215,0),0))
+(IF($i23+$j23>1,-ParametersAFP!$K$60*VLOOKUP($B23-1100,$B$7:$HL$133,215,0),0))
Much appreciated
Bookmarks