Help with a formula based on conditions
I need assistance with creating a formula for the following:
- In the Annual $ cell, I would like the salary to automatically appear when two conditions have been met: the user provided the region (either US, CEMEA, LATAM, ASIA) AND the user has provided the Job Level.
- The salary should come from a different sheet (I have titled it "Reference" sheet).
How can I bring the salary to the first sheet based on the region provided and the job level? Does somebody have a formula to meet this need? ex. someone at the USA in a 32-Sr Manager level would make $42, 254.
Help Article Resources
Check out the Formula Handbook template!