Index & Match with IF statement for specific criteria

Hi all,

This is giving me a head ache this morning:-

=IFERROR(IF(INDEX('NA Top 100 with products v2'!$AL:$AQ,MATCH($B3,'NA Top 100 with products v2'!$AL:$AL),5)="Mfg Products","YES",""),"")

In the Index array, it is only picking up or placing YES, if Mfg Products is the top value (like in VLOOKUP) - but I want it to say yes if it could be the X value down the list in the array; for the matching $B3 number on sheet 1 for instance.

Any thoughts?

Thanks.