Calculating median values from different tables

[AmyYang]

Hi, 

May you kindly see the attached excel. 

I have 2 questions:

1) I tried to use median + filter equation to get the median recruitment rates but it showed #VALUE! error, could you help me fix this?

2) Could you teach me how to get the median recruitment rates from different table sources?

Thank you,

Amy 

[#2]

@AmyYang 

=MEDIAN(FILTER($C$22:$C$24,ISNUMBER(SEARCH(A15,$D$22:$D$24))))

I entered this formula in cell B15 and copied it down to cell B17.

=MEDIAN(FILTER($C$29:$C$31,ISNUMBER(SEARCH(A15,$D$29:$D$31))))

This formula is in cell C15 and copied down.

=MEDIAN(FILTER($C$22:$C$24,ISNUMBER(SEARCH(A15,$D$22:$D$24))),FILTER($C$29:$C$31,ISNUMBER(SEARCH(A15,$D$29:$D$31))))

In cell D15 i entered both formulas from B15 and C15 and copied down to cell D17.