Median IF

Good Afternoon!

I'm having a problem getting the formula right to calculate the median of a column that contains two pieces of data in corresponding cells.

I've attached my excel workbook that I'm working in.

In the "Comparison Data 2" tab I need to calculate the Median in Column E if the Difference (Column A) is located in column M on the Aggregated Raw Data tab.

The median calculation will be calculated from Column F in the aggregated raw data tab if it contains a value from Comparison Data 2 column A in Aggregated Raw Data column M in the same row.

Am I making sense?

The calculation for median should be similar to the calculation for AverageA and AverageB in Comparison Data 2.

Can anyone help?