Results 1 to 3 of 3

Thread: Lookup problem

  1. #1

    Unhappy Lookup problem



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    I am new to this forum . I have attached a file with this post .File has 4 tabs - Skills inventory,skill matrix,leave and attrition.Skills inventory=skill matrix-leave-attrition.

    Skills inventory is unique for Quarter|Year|Moth combination. Skill matrix will show list of people with a perticular 'Main skill|sub skill' combination in a perticular 'Quarter|Year|Month' combination. If 'M' is on leave on a 'Quarter|Year|Month' combination,His skill set must be looked up in skill matrix using 'Name|Main skill|sub skill' combination and appropriate deduction must be made in skill inventory.Similarly If Name 'N' appears in attrition list,His skill set must be looked up in skill matrix using 'Name|Main skill|sub skill' combination and appropriate deduction must be made in skill inventory. Can you please help me to get the formulea right for finding skills inventory
    Attached Files Attached Files

  2. #2

  3. #3
    Thank you so much...It works !!!

Posting Permissions

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