Lookup

[komet12]

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

[Marcol]

Try with sheet tblHistory1

In G2

=INDEX(tblEmployees!B:B,MATCH($A2,tblEmployees!$A:$A,0),0)

Drag/Fill across to J2 then down to end of table


Hope this helps.

If you need any further information, please feel free to ask further

However

If this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody!
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.

[hardeep.kanwar]

Or =IFERROR(VLOOKUP($A:$A,tblEmployees!$A:$D,COLUMN(B:B),FALSE),"")

To Get Rid from #N/A

[komet12]

AWSOME !!!

Thank you both so much. Worked like a charm. I see where my errors were in the code I was tring to write. This is a great learning tool as well as great place for help.