Lookup problem

[nikhil83]

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

[Debraj Roy]

will appreciate.. if you provide some manual output.. with calculation step..

[nikhil83]

I have put manual output in the file in 'Skills inventory' tab