- Joined
- Dec 16, 2012
- Messages
- 2,319
- Reaction score
- 40
- Points
- 48
- Excel Version(s)
- 365
Dead simple: for each row I look in the same table for an exact match with:Can you help explain your objective?
- the negative version of AMOUNT (HOME) column ('negative version' actually means the reversed sign, so +ve it was -ve and vice versa)
- the VENDOR column
- the BATCHNO column
Any row with nothing in the Possibles column means no match has been found at all (which means there are no matches on those 3 columns, so no need to look for any).
Last edited: