Return formula by drop down list

[anna82marie]

So, I have a formula (see below) to return training in date, upcoming and expiring (RAG). This returns the status for the entire workforce. I need to get it to work against a specific row matching the employee name in a separate drop-down. I'm totally stuck!

=IF(IF(H$3="N/A",COUNTIF(H$11:H$1003,"<>"&""),IF(H$3=Data!$A$25,COUNTIF(H$11:H$1003,">"&Data!$C$32),IF(H3=Data!$A$26,COUNTIF(H$11:H$1003,">"&Data!$C$33),IF(H$3=Data!B27,COUNTIF(H$11:H$1003,">"&Data!$C$34),IF(H$3=Data!$A$28,COUNTIF(H$11:H$1003,">"&Data!$C$35),IF(H$3=Data!$A$29,COUNTIF(H$11:H$1003,">"&Data!$C$36),IF(H$3=Data!$A$30,COUNTIF(H$11:H$1003,">"&Data!$C$37),"N/A")))))))=0,"N/A",IF(H$3="N/A",COUNTIF(H$11:H$1003,"<>"&""),IF(H$3=Data!$A$25,COUNTIF(H$11:H$1003,">"&Data!$C$32),IF(H3=Data!$A$26,COUNTIF(H$11:H$1003,">"&Data!$C$33),IF(H$3=Data!B27,COUNTIF(H$11:H$1003,">"&Data!$C$34),IF(H$3=Data!$A$28,COUNTIF(H$11:H$1003,">"&Data!$C$35),IF(H$3=Data!$A$29,COUNTIF(H$11:H$1003,">"&Data!$C$36),IF(H$3=Data!$A$30,COUNTIF(H$11:H$1003,">"&Data!$C$37),"N/A"))))))))

Any help would be appreciated - I've been scratching my head for hours.

A x

 

[AlanY]

would you post a small sample of the data and desired result here

this is your 3rd thread with the same question it's hard for the forum trying to help without some sample data

 

[Fluff]

@anna82marie
Is this question any different to your last two threads?
https://www.mrexcel.com/forum/excel...ependant-formula-post5293197.html#post5293197
https://www.mrexcel.com/forum/excel...-formula-problem-post5293597.html#post5293597

 

[Fluff]

I have temporarily closed the other two threads pending an answer to my above question