Code:
=IFERROR(INDEX('EMPLOYEE LIST'!$BK$2:$BK$1000,AGGREGATE(15,6,(ROW('EMPLOYEE LIST'!$BK$2:$BK$1000)-ROW('EMPLOYEE LIST'!BL$2)+1)/(('EMPLOYEE LIST'!$U$2:$BF$1000=$A$4)),COLUMNS($C$4:C4))),"")
I'm using the above code to pull everyone that has the date that matches A4 in range 'EMPLOYEE LIST'!$U$2:$BF$1000.
What im needing added to the code above is if date (A4) is found in Range 'EMPLOYEE LIST'!$U$2:$AS$1000 in the same row where the name was pulled to CONCATENATE("name","DAT") if false CONCATENATE("name","FTO")
If there is a better route to getting this done or anything that I can add to get the result is greatly appreciated.