Help to return value on two conditions

%3CLINGO-SUB%20id%3D%22lingo-sub-2269946%22%20slang%3D%22en-US%22%3EHelp%20to%20return%20value%20on%20two%20conditions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2269946%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20community%2C%3C%2FP%3E%3CP%3EWould%20be%20grateful%20for%20any%20assistance%20with%20the%20following%20problem%26nbsp%3B%3CSPAN%3EI'm%20trying%20to%20resolve.%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EAs%20shown%20below%2C%20I%20have%20an%20matrix%20of%20data%20from%20which%20I%20am%20trying%20to%20RETURN%20VALUE%20based%20on%20two%20conditions.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20return%20a%20value%20in%20C3%20(i.e.%20median%20salary)%20based%20on%20job-family%20C1%20AND%20carreer%20step%20C2%20in%20my%20excel.%20I%20cannot%20find%20the%20right%20search%20formula%20in%20C3%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22HeleneSweden_0-1618314053735.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F272430i3D391039D0BD1783%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22HeleneSweden_0-1618314053735.png%22%20alt%3D%22HeleneSweden_0-1618314053735.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EGreatful%20for%20the%20help%20I%20can%20get!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%3C%2FP%3E%3CP%3EHelene%20Sj%C3%B6blom%2C%20Scania%2C%20Sweden%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2269946%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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 

 

HeleneSweden_0-1618314053735.png

Greatful for the help I can get!

 

Best regards

Helene Sjöblom, Scania, Sweden

3 Replies

@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!

 

Thank you @Riny_van_Eekelen 

It works! You saved me ALOT of hours

@HeleneSweden Var så god!