Maybe this
in H3
=IFERROR(INDEX(D:D,AGGREGATE(15,6,ROW(B3:E4)/(($B$3:$B$4=G3)*($E$3:$E$4=TRUE)),ROWS(I$3:I3))),"")
Row\Col B C D E F G H 2Lookup Number Bid Amount lookup return testCriteria Return 3 14-0555 $171,057.00 $171,057.00 TRUE 14-0555 171,057.00 4 14-0555 $49,800.00 $171,057.00 FALSE
Bookmarks