Quote Originally Posted by Punnam View Post
Formula: copy to clipboard
=IFERROR(INDEX($B$1:$B$13,SMALL(IF(($A$1:$A$13="044")*($C$1:$C$13="Blank"),ROW($A$1:$A$13),""),E$2)),"")


Try this
use Ctrl+ Shift+Enter

Punnam
Fantastic! That worked a treat - Thank you sooooooo much!