Apr 13 2021 04:46 AM
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
Apr 13 2021 05:26 AM
@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!
Apr 13 2021 06:21 AM
Thank you @Riny_van_Eekelen
It works! You saved me ALOT of hours :)