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

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

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.

Quote:

---

Originally Posted by 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.

---

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

experts please reply