Hi Everyone,

I am really hoping someone will be able to help me with this, I will explain what I am trying to do just in case you can suggest a better way for me to achieve the same outcome.

I have a master spreadsheet (MSS) which has rate details of employees, each employee falls into a banding code e.g. Joe blog's banding code is 123, 123 is a banding of $100 to $300 for African on a 5 hour day, all my coding references are on a separate spreadsheet, what I need to do work out the percentage in which Joe Blogs rate sits with in a particular banding.

What I am finding hard is the fact that I need excel to reference the employees location and hours per day to then reference the correct banding to then determine the percentage the persons rate sita in the banding.

At present I have done the following:
- The MSS and the bandings in the same document
- I have the following formula to work out where the rate sits in the band:
Top End - Bottom End = Range
Rate - Bottom End = X
X / Range x 100 = Percent (figure I want to show against each person)

What I need this formula to do is reference the persons location, hours and code, then work out the percentage their rate sits in the banding.

The formula I have started to try is:

=IF(AND([@[Point of Origin]]="Africa",Table3[[#Headers],[Hours Per Day]]="5"),S11=VLOOKUP([@[Job Classification Code]],'Africa!D11:P226,4,FALSE),)
this is not working it just comes up with a "0".... and I am not even sure if this is the best way to do this?

PLLEEEAAAAASSSEEEEEEE HELP ME