Hello,

The following formula works for me with Ctrl+Shift+Enter
=INDEX($R$6:$R$1484,MATCH(MIN(ABS($R$6:$R$1484-J6)),ABS($R$6:$R$1484-J6),0))

where R is Amount nearest to J6 value. The goal now is to introduce another matching criteria to this formula. I want to add contractor number as the second match criteria and this should match exact.

J6= 100 (where J6 is Amount)
B6 = 1800 (Where B6 is the number of the contractor who paid the J6 amount)

How do I add the additional criteria? Please help!