Hello, Microsoft Excel Community.
I'm not sure if there is a VLOOKUP formula that will do what I need, but there must be something out in MS formula land to return accurate results for duplicative information.
Here's an example:
I have the same violation in three subsequent records in my spreadsheet because there were three separate payments on the violation and three separate commission amounts on the violation. But the VLOOKUP only returns the match on the first record. A simple vlookup can't look at the same violation number on records 2 and 3 to return the unique values under the columns beginning with "My..." on records 2 and 3. It just pulls in the same data from record 1.
Is there a way to edit the formula to have it look at the violation number on records 2 and 3 and have it return the values in the data
| Violation | My Transaction Amount | My Commission Amount | XYZ Transaction Date | XYZ Transaction Amt | XYZ rnd Commission Amount |
| 134883599 | $26.66 | $2.52 | 5/6/2021 | $ 26.66 | $ 2.53 |
| 134883599 | $86.05 | $8.15 | 5/6/2021 | $ 26.66 | $ 2.53 |
| 134883599 | $88.94 | $8.42 | 5/6/2021 | $ 26.66 | $ 2.53 |
