I need a formula to return the ref # from table #2 so I have the ref # in table #1. I'd need the formula to be based on date and and amount as those would be the only unique identifiers given that the numbers have the potential to repeat themselves, that's where the date criteria would come in but there's still a chance that the same number will be present on that particular date. I was trying VLOOKUP/MATCH with no luck.
Any help would be appreciated.
Any help would be appreciated.
Table #1Date | Details | Amount | Ref # | |
01/03/2023 |
| 2,368.26 | ? | |
| | | |
Table #2Date | Details | Amount | Ref # | |
01/03/2023 |
| 2,368.26 | 12614 | |
| | | |