Originally Posted by Punnam Formula: =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!
=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)),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Forum Rules
Bookmarks