Help Needed: Formula based on 2 criteria to pull one result needed If and???

[jonnieRC]

Hi Folks,

I really need some help on a formula that i cannot figure out. I was thinking an IF and formula with some vlookups or something but i cant get it to work.

Based on the attached file i need a formula in the data tab under "Step" that basically uses the 2 criteria in yellow, pulling from the Rate summary tab and what i need is the corresponding number in Red at the top of the Rates Summary file. Not sure if this makes sense or is possible.

So i need the number in red that is based on the rate of 27.33 and the jobcode QARVPO, which is Step 15.

Any help would be great,

Thanks,
John

 

[David Evans]

It appears you don't have a JobCode QARVPO on your Rates Summary sheet which makes it difficult to cross reference it with any column headings

 

[jonnieRC]

HI David,

Apologies, I have added a line now with some detail for that Jobcode.

Thanks,
John

 

[rahulshewale1]

Hii,

see if this is ok?

Regard
Rahul shewale

 

[bosco_yip]

Maybe,

In E2, formula copied down :

=IFERROR(OFFSET('Rates Summary '!C$1,0,MATCH(D2,INDEX('Rates Summary '!D$2:Q$100,MATCH(A2,'Rates Summary '!$B$2:$B$100,0),0))),"")

Regards
Bosco

 

[jonnieRC]

Thanks folks, that worked perfectly.

Appreciated.

Kind regards,
John