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!
Bookmarks