You had C2 instead of A12 in LOOKUP VALUE.![]()
=IF(B12>999,(VLOOKUP(A12,RATEMASTER!$C$2:$H$20,4,FALSE)+B12*VLOOKUP(A12,RATEMASTER!$C$2:$H$20,5,FALSE))*VLOOKUP(A12,RATEMASTER!C2:H20,6,FALSE),IF(B12=500,VLOOKUP(A12,RATEMASTER!$C$2:$H$20,3,FALSE)*VLOOKUP(A12,RATEMASTER!$C$2:$H$20,6,FALSE),IF(B12=250,VLOOKUP(A12,RATEMASTER!$C$2:$H$20,2,FALSE)*VLOOKUP(A12,RATEMASTER!$C$2:$H$20,6,FALSE),0)))
Bookmarks