Formula to return a unique Rate basis n number of conditions.

  • Hi All,


    I am trying to build a formula that returns a monthly rate basis a couple of criteria.


    I tried using nested if's but something's going wrong.


    I have attached my spreadsheet for reference. The rate card to the right of the sheet is the basis for my calculation. The logic is: A certain Role against a certain location should return a unique rate.


    For example if I select the role as developer from the Validation and Onshore as location from its validation then formula should return the rate as $20.00.

  • Re: Formula to return a unique Rate basis n number of conditions.


    =indirect("r" & match(b2,l:l,0) & "c" & match(c2,10:10,0),0)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!