Help with complex formula - H and VLOOKUP

Forgot to mention, any help suggestions etc would be most welcome as I am not 100% sure that it is even possible to do this, as never really used lookup before and certainly not to this extent.

Thanks

Do you want logic like this?

IF there is an exception, apply that rate; if not, apply the standard rate (according to grade)

Originally Posted by TheNorm

Do you want logic like this?

IF there is an exception, apply that rate; if not, apply the standard rate (according to grade)

That's what I've been trying to work out - So I can use the IF formula -

So what I need to do is to say if Test Project has the word 'different' in the rate column it means that the rate will be different than the set amount already in our system so what I need to do then is find a way of doing the following -

If rate is different, lookup the standard rate and then change it to the rate entered so if standard was 250 and the entered varying rate was 275 it would change this as well as another rate for the same project, say 230 and change it to 200.

I have very limited knowledge of Excel so any help in terms of formula to try would be most gratefully received.

Thanks

Russ

hey supraruss,

i have a fairly complex spreadsheet for a consulting firm I made already (i'm a consultant also) with varying rates, etc. etc. etc.

I'm not sure what the end result you are trying to get is, but mine may interface into your's, or maybe there is a work around to what you are trying to actually achieve...

if you private message me, i'll send you my email and you can zip and upload your file, and I'll try to add-in my template for you.

robert

Originally Posted by NBVC

I'm a little confused... I see your Vlookup formulas...but am not sure what you finally want...

Does this formula in J22 do what you need? =INDEX(C2:F41,MATCH(J13,Client,0),MATCH(L13,C1:F1,0))

Whoa, I think we are on to something here! That's brill, did it take you long to come up with that? Never really used match before.

I am waiting for comfirmation from another chap to see if we can impliment this into the existing system and bingo!

Thanks so much for your guidance. When you said cell J22 I was trying to get the formula you have written but obviously completely different!