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