count and index issue

hello

having some issues with my formula...i am running a contest and my data is not being captured correctly.

in sheet "CSA Details breakdown" the person input their data (ie. name column D and revenue column L). however, in cell P16 (highlighted red), the row does not activate.

the reason why i need it to show data is b/c the payout in the "rps conest payout" sheet, should show in cell D40 for P10 the person's name and deal.

the issue seems to be in the person name. I use "john doe" in the "csa detail" worksheet, however if i change in cell D16 to "j. doe"...for formula picks it up

formula in P16:
=IF(G16='RPS Contest Payout'!$D$37,IF(COUNTIF($D$14:D16,D16)=1,ROW(),""),"")


can someone pls help as it's causing a major issue, pls and thx u