If & Index and Match

Could someone kindly advise the most appropriate formulae to use please

In Tab 2016 List, Column B6 I have the word Exec, Cell B7 = G etc.

In Column D6 I want to look up the average salary from another tab. Also in Column L6 I have the word Permanent or PTS

My second tab is labellled Avg Rates

Column = Exec, G, H, F etc.

Column B has the Permanent Salary = $50,000 example

Column C = PTS

So my formulae would say If L6 = Permanent, Lookup in tab Avg Rates tab column A8 for Exec, and put the value in Column B8 which is permanent into cell L6

Thanks

OK - Thanks for the input.

I have attached a spread sheet that will better explain what I am trying to achieve.

In Tab 2016 list, Column C I am trying to pull the Avg. rates from the second tab. It is looking at column B and L in the first tab and matching this to Columns A to E in second tab

Please advise the best formulae to use.

Thanks