Help with complex formula - H and VLOOKUP

Hello everyone,

Hoping some of you may be able to assist with a formula I am trying to work out (apologies if I have posted in the wrong section as this is my first post).

If I explain what I need to do, hopefully someone may be able to assist?

We have 4 levels of hourly rate and lets say 100, 200, 300 and 400 to make things simple. The rate depends on the person working on the client, so 100 would be a consultant and 400 a director.

We have certain clients that we agree a set fee so that anyone working on them, we use an exception and we have a formula to find this. What we do is copy the name of the client into a table and add the new set rate and our formula looks at this table and takes the set rate from here. If the client name isn't in the table, it takes the standard rate from a data sheet depending on consultant.

What I now need to do is try and find out a way to lookup so we can use a changed variable rate - so if one consultant is usually 200 we have agreed 250 for them and another that is 400 we have agreed 350 and so on.

Its very confusing if you haven't seen the spreadsheet, but hoping there is a way of getting the spreadsheet, or a printscreen posted, if anyone can help?

forgot to add the formula so far (??? is what I need to work out to find a variable rate)

F(ISERROR(VLOOKUP(B" & i & ",exeptions,2,FALSE)),???(VLOOKUP(S" & i & ",rate,HLOOKUP(A" & i & ",since,2,TRUE),FALSE)),VLOOKUP(B" & i & ",exeptions,2,FALSE))

Thanks very much

Russ