Try it,

D4
=IF($B4="","",INDEX('RMS Sales'!N:N,MATCH($C4,'RMS Sales'!$A:$A,0),1))
copied to E4, copied down.

HTH,
WindKnife