Lookup Multiple Combination Of Values Across Columns To Find Corresponding A Value

[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

[Excel Fox]

Can't see the attachment. Please try again. If the file size is above the forum limit, try zipping the file. If it's still beyond forum limit, then try to upload the file on to a file sharing site, and post a link here.

[nikhil83]

Can't see the attachment. Please try again. If the file size is above the forum limit, try zipping the file. If it's still beyond forum limit, then try to upload the file on to a file sharing site, and post a link here.

I have attached it once more.Its a 15 KB File

[nikhil83]

experts please reply