I have a workbook that has 2 sheets in it, One is Employees ID, Fname,Last,Middle the other is a listing of classes that have been completed also using ID as the key. What I am tring to do is have a formula that will look at sheet 1 and compare the ID then go to sheet 2and put name in the required fields. This sheet is well over 100,000 Classes that are completed by about 3000 employees.
A sample of the woorkbook enclosed
Bookmarks