Help to return value on two conditions

[HeleneSweden]

Hello community,

Would be grateful for any assistance with the following problem I'm trying to resolve.

As shown below, I have an matrix of data from which I am trying to RETURN VALUE based on two conditions.

I need to return a value in C3 (i.e. median salary) based on job-family C1 AND carreer step C2 in my excel. I cannot find the right search formula in C3 

Greatful for the help I can get!

Best regards

Helene Sjöblom, Scania, Sweden

[#2]

@HeleneSweden If you are a MS365 subscriber, you can use FILTER.

In C3:

=FILTER(C4:C22,(A4:A22=C1)*(B4:B22=C2))

Working example attached.

Har det bra!

[#3]

Thank you @Riny_van_Eekelen 

It works! You saved me ALOT of hours :)

[#4]

@HeleneSweden Var så god!