INDEX/MATCH multiple lookup values

I have a spreadsheet that contains duplicate lookup values that are not allowing me to pull the correct data. I've attached an example.



Is there a way--without using a pivot table--to pull the correct information from the second lookup value?

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
2	Lookup Number	Bid Amount	lookup return	test		Criteria	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

Thanks AlKey

Is there a way to bring up the 'Bid Amount' value from cell C4 if false? I'm trying to do a lookup that brings me the correct 'Bid Amount', so for example for cell B3 it is $171,057 and for cell B4 it would be $49,800. The index/match formula keeps bringing up the value from B3 into D4.

I'm a little new to this so my apologies if my explanation is not clear.

Yes, use the same formula and replace TRUE with FALSE.

=IFERROR(INDEX(C:C,AGGREGATE(15,6,ROW($B$3:$E$4)/(($B$3:$B$4=G3)*($E$3:$E$4=FALSE)),ROWS(I$3:I3))),"")

See updated INDEX range.