Lookup name and return dependant formula

[anna82marie]

I think I've over stretched myself with this one:

I've created training matrix for a maintenance company with 300+ employees. I've figured out a formula to return In date, upcoming (90 days), and expired courses for al employees.

=IF(IF(I$3="N/A",COUNTIF(I$9:I$1001,"<>"&""),IF(I$3=Data!$A$25,COUNTIF(I$9:I$1001,">"&Data!$C$32),IF(I3=Data!$A$26,COUNTIF(I$9:I$1001,">"&Data!$C$33),IF(I$3=Data!C27,COUNTIF(I$9:I$1001,">"&Data!$C$34),IF(I$3=Data!$A$28,COUNTIF(I$9:I$1001,">"&Data!$C$35),IF(I$3=Data!$A$29,COUNTIF(I$9:I$1001,">"&Data!$C$36),IF(I$3=Data!$A$30,COUNTIF(I$9:I$1001,">"&Data!$C$37),"N/A")))))))=0,"N/A",IF(I$3="N/A",COUNTIF(I$9:I$1001,"<>"&""),IF(I$3=Data!$A$25,COUNTIF(I$9:I$1001,">"&Data!$C$32),IF(I3=Data!$A$26,COUNTIF(I$9:I$1001,">"&Data!$C$33),IF(I$3=Data!C27,COUNTIF(I$9:I$1001,">"&Data!$C$34),IF(I$3=Data!$A$28,COUNTIF(I$9:I$1001,">"&Data!$C$35),IF(I$3=Data!$A$29,COUNTIF(I$9:I$1001,">"&Data!$C$36),IF(I$3=Data!$A$30,COUNTIF(I$9:I$1001,">"&Data!$C$37),"N/A"))))))))

Now I need to amend it to return the data for a specific employee selected from a drop down, but I just can't get my head around it...HELP!

 

[Special-K99]

Not saying I'll answer this but this looks odd (see red highlights)

=IF(IF(I$3="N/A",COUNTIF(I$9:I$1001,"<>"&""),IF(I$3=Data!$A$25,COUNTIF(I$9:I$1001,">"&Data!$C$32),IF(I3=Data!$A$26,COUNTIF(I$9:I$1001,">"&Data!$C$33),IF(I$3=Data!C27,COUNTIF(I$9:I$1001,">"&Data!$C$34),IF(I$3=Data!$A$28,COUNTIF(I$9:I$1001,">"&Data!$C$35),IF(I$3=Data!$A$29,COUNTIF(I$9:I$1001,">"&Data!$C$36),IF(I$3=Data!$A$30,COUNTIF(I$9:I$1001,">"&Data!$C$37),"N/A")))))))=0,"N/A",IF(I$3="N/A",COUNTIF(I$9:I$1001,"<>"&""),IF(I$3=Data!$A$25,COUNTIF(I$9:I$1001,">"&Data!$C$32),IF(I3=Data!$A$26,COUNTIF(I$9:I$1001,">"&Data!$C$33),IF(I$3=Data!C27,COUNTIF(I$9:I$1001,">"&Data!$C$34),IF(I$3=Data!$A$28,COUNTIF(I$9:I$1001,">"&Data!$C$35),IF(I$3=Data!$A$29,COUNTIF(I$9:I$1001,">"&Data!$C$36),IF(I$3=Data!$A$30,COUNTIF(I$9:I$1001,">"&Data!$C$37),"N/A"))))))))

C27 not A27 ?
I say this as your IFs are checking against A25 A26 A28 A29 A30 but not A27 ?