Can anyone see any errors in this array formula ?
I had it working sometime ago, but just tried again and it returns a blank cell.
=IFERROR(LOOKUP(2,1/(SMALL(IF('[Sales 2016.xlsm] Nc Orders'!$K$13:$K$206<>"",'[Sales 2016.xlsm] Nc Orders'!$K$13:$K$206+'[Sales 2016.xlsm] Nc Orders'!$L$13:$L$206),ROW(A1))=IF('[Sales 2016.xlsm] Nc Orders'!$K$13:$K$206<>"",'[Sales 2016.xlsm] Nc Orders'!$K$13:$K$206+'[Sales 2016.xlsm] Nc Orders'!$L$13:$L$206)),'[Sales 2016.xlsm] Nc Orders'!$B$13:B$206),"")
Thanks
Bookmarks