What I want is for excel to know that when a unique number has already appeared in a column and move on to the next result(unique identifier) that satisfies the same two criteria. This way I can reference which bank and which account. In my original spreadsheet, attached above, my accounting system has four $350 cash receipts, while the bank has only three. I have assigned each bank deposit a "unique identifier". When the period and dollar amount, from the accounting system, matches the first occurrence of the same, in the bank statement, then it needs to return the first unique identifier. That UI should then be taken out of inventory so to speak. when the same amount and period appears again, excel should not pull the same unique identifier, but the next one that satisfies the same two criteria