Hi there,

I'm seeking to figure out a VLOOKUP or alternative function to find a matching record that is between two date ranges, and also matches a sender and receiver name, returning a transaction ID.

Source Data
A | B | C
Date | Sender | Recipient
4-Apr | John | Sandy

Lookup Data
A | B | C | D | E
Low Date Range | High Date Range | Sender | Recipient | Transaction ID
3-Apr | 5-Apr | John | Sandy | ID 1
6-Apr | 7-Apr | John | Sandy | ID 2
3-Apr | 5-Apr | Albert | Sandy | ID 3

In this case, ID 1 should be returned, because the date is between the Low and High Date Range, and John and Sandy Match Sender and Recipient respectively.

Thanks for any help you can provide!