INDEX/MATCH multiple lookup values

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.