Quote Originally Posted by Fotis1991 View Post
So in G40 you need a result of 0 ???
G40 will have a number in it (percentage) which is listed on the Pay Lookup Table with the appropriate amount next to it. I need D40 to lookup G40 and give the value for it in the table but read the correct column (INDEX) in the table for the Grade A,B,C,D or E as specified in cell G2.

Hence an employee' work is timed and whatever percentage (cell G40) they have worked at over the week will give the hourly rate. Each employee then has a variable Grade so e.g. Grade A at 100% would be paid 8.93 per hour whereas if the employee is Grade C they would get 7.755 per hour. I need a formula that firstly looks at the Grade given in cell G2 then reads the corresponding column in the Pay Lookup Table for that Grade and the percentage given (cell G40).

I'm truly sorry for the confusion