with forum got following array formula together.
=iferror(index(salesorderline, small(if(salesorderline[salesorderid]=salesorderid, row(salesorderline[salesorderid])-1, if(salesorderline[salesorderid]=salesorderid2, row(salesorderline[salesorderid])-1)), rows(a$23:a23)), 13),"") unfortunately formula working when both criterias salesorderid , salesorderid2have data. see result first criteria if second criteria salesorderid2 has no data.
given comments below - revised version:
=iferror(index(salesorderline,small(if(isnumber(match(salesorderline[salesorderid],choose({1,2},salesorderid,salesorderid2),0)),row(salesorderline[salesorderid])-min(row(salesorderline[salesorderid]))+1),rows(a$23:a23)),13),"")
confirmed ctrl+shift+enter
choose function creates "array" of 2 ids. match function still produce valid results when matched against array, if of values errors.
