I have worked this out how to return a numerical value but not a text value
In column B is the employees payroll number, in column G is the date they start their leave and in column H is when they finish their leave
On another sheet Is 'Employee A's payroll number in cell E5 with a date in G4
What I want is, if E5 can be found in Column B and if G4 can be found in column H then it should return the value from column D
The payroll number in B and the dates in column G can appear muliple times, so this should only return a value if both date and payroll number match.. Any ideas please ?
In column B is the employees payroll number, in column G is the date they start their leave and in column H is when they finish their leave
On another sheet Is 'Employee A's payroll number in cell E5 with a date in G4
What I want is, if E5 can be found in Column B and if G4 can be found in column H then it should return the value from column D
The payroll number in B and the dates in column G can appear muliple times, so this should only return a value if both date and payroll number match.. Any ideas please ?