Data pull based on multiple criteria

Ok so here goes. I have tried to search the forum and youtube but i think i have the names of the functions wrong so i will do my best to explain.

To provide some context we have multiple contractors who provide us different types of crews, such as the following

Dual Working Vehicle
2 Man
1 Man
Welfare
IPV

Although the crews are the same the rates vary from each contractor.

Each month i download a standardised report, the Columns range from A-K

Column G = Contractor name
Column F =Crew type as listed above
Column K = Rate

The rates i have on a separate tab and list out with the contractor names listed out down column A and the crew types cross columns in Row A

What i want to do i think consists of a Vlookup with IF parameters but i am a little lost. basically something along the following lines

IF G =(name)+ F(crew type) K = (rate)

Thanks in advance for any help

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

Administrative Note:

Members will tailor the solutions they offer to the version (NOT release number) of Office (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.

Which version of Excel are you using? Windows 10 is your operating system.

i am using version 2202

thanks

That's a release number. Which version? Excel 2019? Excel 2021? MS365?

it is 365 sorry

Thanks - then please update your profile.

Please explain where £300 is coming from:

AliGW on MS365 Insider (Windows) 64 bit

	J	K	L
1	Service Duty TimeSheet Number	Rate
2	18CompanyA0602	£300	Rate for example

Sheet: Report

Is this ist?


=IFERROR(INDEX(Rates!$B$2:$O$5,MATCH(G2,Rates!$A$2:$A$5,0),MATCH(F2,Rates!$B$1:$O$1,0)),"")

Well, it won't drag correctly without the $ for sure... but since you haven't (yet) told me what you've "taken out" I have to rely on my trusty crystal ball for help...

Post a realistic sample sheet showing the problem.

Woo Hoo! Fixing it yourself is always more satisfying, too!!

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please select "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.