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
Bookmarks