Index match with multiple criteria and return the most recent date?

[paulinho110]

Hi Gents,

Can someone please help me out with this greatest challenge I have ever came across?

I have a matrix spreadsheet where the column B held the team member names and from column D onward have the headers with the skill code that must be look upon the register table.

Here is the current formula I am using but it just return the first match =(

=IF(IFNA(INDEX(T_RECORD[[EXPIRY DATE]:[EXPIRY DATE]], MATCH(MAT_DEV[#Headers]&MAT_DEV[[Employee]:[Employee]],INDEX(T_RECORD[[QUAL. ID]:[QUAL. ID]]&T_RECORD[[NAME]:[NAME]],),0)),"")=0,"",IFNA(INDEX(T_RECORD[[EXPIRY DATE]:[EXPIRY DATE]], MATCH(MAT_DEV[#Headers]&MAT_DEV[[Employee]:[Employee]],INDEX(T_RECORD[[QUAL. ID]:[QUAL. ID]]&T_RECORD[[NAME]:[NAME]],),0)),""))

In sum, I need to return from T_RECORD the Greatest Expiry Date into the MAT_DEV table...

Please

 

[Aladin Akyurek]

Care to post the portion of the table that consists of 5 rows and 5 columns and the desired result for that bit?