In my example below, based on value in B16, I would like a formula in C16 to look through column C4:C8 and E4:E8 for this value. If found I would like the values in either D or F multiplied by the value in column H and summed together. The resulting formula of for the result I would like is shown below in H15. This is a small sample size of the actual data table.