I think I need an INDEX MATCH formula here but I just can't figure it out.
Sheet 1
<tbody>
Payee (B)
Amount (C)
Date (D)
1
Payee 1
130.08
April 20, 2018
2
Payee 2
40.00
April 21, 2018
3
Payee 3
131.25
April 6, 2018
4
Payee 4
145.59
April 29, 2018
</tbody>
-----
Sheet 2
<tbody>...