Hi Everyone,
I have a table where I'm trying to lookup a transaction ID for a particular sales member. I'm not sure how to approach this and my efforts around an IF( AND( VLOOKUP( formula have proved futile.
The following tables show what I'm trying to accomplish.
TABLE 1
<tbody>...