Hello Excel gurus,
I am doing our employee database maintenance between our Payroll Database and NetSuite database. However, I am running into some issues that I need your expert help.
The problem I have is our payroll database have employees (without middle name initial) and correct updated their married name. Our NetSuite, in the other hand, has employee with middle name initial and has either go by name or their maiden name.
On Payroll work book, I have First Name, Last Name, Name, Department, and Company
On NetSuite work book, I have Name (include middle initial), Department, and Company.
Goal: trying to validate NetSuite department and company against payroll workbook.
How or what formula I need to use in order to achieve this goal?
Thanks much.
I am doing our employee database maintenance between our Payroll Database and NetSuite database. However, I am running into some issues that I need your expert help.
The problem I have is our payroll database have employees (without middle name initial) and correct updated their married name. Our NetSuite, in the other hand, has employee with middle name initial and has either go by name or their maiden name.
On Payroll work book, I have First Name, Last Name, Name, Department, and Company
On NetSuite work book, I have Name (include middle initial), Department, and Company.
Goal: trying to validate NetSuite department and company against payroll workbook.
How or what formula I need to use in order to achieve this goal?
Thanks much.
Last edited: