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
Last edited by komet12; 06-24-2010 at 07:22 AM. Reason: solved
Try with sheet tblHistory1
In G2
Drag/Fill across to J2 then down to end of table
Please Login or Register to view this content.
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.
Or =IFERROR(VLOOKUP($A:$A,tblEmployees!$A:$D,COLUMN(B:B),FALSE),"")
To Get Rid from #N/A
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks