Hi there,
I have 2 sheets containing various employee data - one sheet named 'Employee data' contains the Employee Full Name (in column A) and the other sheet named 'Employee with Samsung' contains Employee Full Name (in column A) along with 'Device Details' (in column B of this sheet).
I need a formula to look up the Employee Name from 'Employee Data' sheet and match it to the Employee Full Name from 'Employee with Samsung' sheet and if it finds it to then retrieve the 'Device Details' from this sheet and populate it into the Device Details (column B) within the 'Employee Data' sheet.
I hope that makes sense...
Grateful for any assistance - thank you in advance
I have 2 sheets containing various employee data - one sheet named 'Employee data' contains the Employee Full Name (in column A) and the other sheet named 'Employee with Samsung' contains Employee Full Name (in column A) along with 'Device Details' (in column B of this sheet).
I need a formula to look up the Employee Name from 'Employee Data' sheet and match it to the Employee Full Name from 'Employee with Samsung' sheet and if it finds it to then retrieve the 'Device Details' from this sheet and populate it into the Device Details (column B) within the 'Employee Data' sheet.
I hope that makes sense...
Grateful for any assistance - thank you in advance