I want to match DT1 “Life Cover amount” with DT2 “Life_Cover” column data and get the lifePremium . But when there is no exact match related to DT1 life cover amount then it should capture the greater value from the DT2 Life_Cover column related to DT1
exaple as follow;
DT1 life cover = 100,000.00
should match the greater value from the DT2 Life_cover as 110,000.00
hope you understand my scenario and earliest response on this regard much appreciated.