Results 1 to 4 of 4

Lookup

Threaded View

komet12 Lookup 06-23-2010, 06:06 PM
Marcol Re: help with lookup 06-23-2010, 06:55 PM
hardeep.kanwar Re: Lookup 06-23-2010, 11:06 PM
komet12 Re: Lookup 06-24-2010, 07:21 AM
  1. #1
    Registered User
    Join Date
    10-22-2009
    Location
    Roanoke, indiana
    MS-Off Ver
    Excel 2010
    Posts
    94

    Lookup

    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
    Attached Files Attached Files
    Last edited by komet12; 06-24-2010 at 07:22 AM. Reason: solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1