Hi,
I have the below tables and I am trying to match back avalue from a separate product table & then output a calculation dependingon the value found.
I have the below formula which looks fine to me but I cantfigure out why it only returns a 0 value.
The formula should find Product Fabric under Product Code inthe Product table & then Multiply the value under total premium * thecommission % in the product table.
=SUM(LOOKUP(C:C,'Product Table'!A:A,D:D)*Product Table!B:B)
<tbody>
</tbody>
<tbody>
</tbody>
I have tested this formula with simplified tables and itworks fine , I just cant figure out why it is not working on the above tables.
Any help is greatly appreciated.
Thanks
I have the below tables and I am trying to match back avalue from a separate product table & then output a calculation dependingon the value found.
I have the below formula which looks fine to me but I cantfigure out why it only returns a 0 value.
The formula should find Product Fabric under Product Code inthe Product table & then Multiply the value under total premium * thecommission % in the product table.
=SUM(LOOKUP(C:C,'Product Table'!A:A,D:D)*Product Table!B:B)
Insurance | Insurance Policy | Product Fabric | Total Premium | Net premium | Tax Quantity 1 | Commission amount | Commission amount - Validation |
21 | xxxxxx | FAMPD | 3227 | 1746 | 0 | 1481 | 0 |
21 | yyyyy | FAMPC | 1849 | 1109 | 0 | 740 | 0 |
PRODUCT CODE | Commission |
xxxxxx | 40.00% |
xxxxxx | 40.00% |
xxxxxx | 40.00% |
xxxxxx | 40.00% |
xxxxxx | 40.00% |
yyyyy | 45.88% |
yyyyy | 45.88% |
yyyyy | 45.88% |
yyyyy | 45.88% |
yyyyy | 45.88% |
I have tested this formula with simplified tables and itworks fine , I just cant figure out why it is not working on the above tables.
Any help is greatly appreciated.
Thanks