Hi ,
Im trying to map the cases present in the sheet 1 to Sheet 2. Here the sheet2 I have highlighted the rows yellow color that needs to be updated by using excel formulas.Here the sheet should be updated with the description below mentioned along with the formulas..Highlighted cells in the sheet2 is B,C,I,J,T,U. I have designed the below condition in the same order
B cells should be updated with the refernce of Sheet1 with the below condition:
Identify the "(B Value)"Claim with below condition (D Value)
C cells should be updated with the refernce of Sheet1 with the below condition:
Verify wether (I Value) Mapped to the below Coverage in CAS (K value)
C cells should be updated with the refernce of Sheet1 with the below condition:
Verify wether the Incident (Q value)is below for the Coverage (K Value)
J cells should be updated with the refernce of Sheet1 with the below condition:
Verrify the the Exposure type(P) is below for the Coverage (K)
T cells should be updated with the refernce of Sheet1 with the below condition:
Verify the cost created the reserve coverage (K value) is below (N value)
U cells should be updated with the refernce of Sheet1 with the below condition:
verify the line category of the payment done on the coverage
(X value of all the conditions for Sheet1 value)
Thanks in advance,
Lax
Bookmarks