Based on Condition Track ID, Values to be return in Column C

[Mohammad Munawar]

Hi,

Required a formula help for to be return a values as per conditions based on Track ID. I have a data set like column A to D contains Headers (Track ID, Total Qty, Allowable value, Actual value),and in column G to H (Track ID, Rates)

As per track ID ,there mentioned total quantities (In column B) to be multiply with rates (Column H) and return the values in column C, and some where there is no rates are available for example (Track ID-321563,215632)
does not have the rates, at that condition the same values to be return in column C which are exist in Column D.


Sample sheets with expected results are enclosed.


Thanks,