Scenario:
One workbook
Sheet1 contains and employee name and an employee number
Sheet2 contains a variation of the employee name (so and exact match is not possible)
Sheet3 needs to contain the employee number from sheet1 based upon the match of the employee name on Sheet1 with that of Sheet2 to provide the corresponding employee number
I may have to split the three sheets into three separate workbooks, but not sure yet.
I have considered variations of INDEX and MATCH statements and VLOOKUP, but have not been able to return the value desired.