Look up and return data from a Description

your orginal formula works perfect for the itmes in green
=SUMPRODUCT((LEFT($C$3:$C$500,3)="ESH")*($C$3:$C$500<>""),($N$3:$N$500))


Using the items highlighted in yellow and orange as an examples,
Both share the Description SHA, but are in fact different, Colum B shows the difference, one is LHL(405) and the other is N/L(405)
Is there a way a formula could look up at N/L(405) Colum B then look at SHA Colum C and returns column N


Paul