Hi, not entirely sure I follow but perhaps try following;

1. created a dynamic named range re: rates (so you avoid overly large range processing)

Formula: copy to clipboard 
Name: _TrustRates

RefersTo: ='Trust Rates'!$A$1:INDEX('Trust Rates'!$A:$IV,MATCH(REPT("Z",255),'Trust Rates'!$A:$A),MATCH(REPT("Z",255),'Trust Rates'!$1:$1))

2. with the above in place, you could try below in Column AG on your Data tab:

Formula: copy to clipboard 
AG3: 

=INDEX(_TrustRates,ROUND(10^4*MOD(AGGREGATE(15,6,((ABS(ROUND(INDEX(_TrustRates,0,7)-$L3,2))*10^7)+(ROW(INDEX(_TrustRates,0,1))/10^4))/(INDEX(_TrustRates,0,2)=$Y3)/(INDEX(_TrustRates,0,3)=W3),1),1),0),1)

copied down

above would return following results:

TrustJob1DPOST
TrustJob1N
Trust2Job1D
Trust2Job1N
Trust3Job2D
Trust4Job5Dbreak
Trust4Job1N
Trust5Job4DPRE
Trust5Job4NPRE
Trust6Job3D