Hi Guys,
I am basically trying to extract the hourly rates from sheet 2 to sheet 1 based on role/status but it's only doing it correctly for permanent employees.
I am using this formula:
see the attached sheet to better understand this problem.Please Login or Register to view this content.
Thanks!!
SAMPLEEEE_.xlsx
Bookmarks