FYI, This is what I currently have:
Code:
=ROUND(IFERROR(VLOOKUP(VALUE(P1398),FEE!$A$4:$B$118,2,0),VLOOKUP(TEXT(P1398,0),FEE!$A$4:$B$118,2,0))*(J1398),2)
Delighted to find that even for the entries that multiply times zero, the results are zero (not #N/A or #DIV).
