I need some guidance on how I can take info from one tab in a workbook and check 2 columns for matching data in another tab. Then if it finds a match for both on the same line it would note that someway.
My first Tab sheet looks like this:
<tbody>
</tbody>
My Second Tab looks like this:
<tbody>
</tbody>
Now.. in the first TAB above in Column "G" i would like it to check if the amount in B and date in A and find that line in the second Tab in columns G (for the amount) and C (for the date).
Then if it finds a match it would let me know YES or NO in column G in the first TAB.
I have tried this with vlookup but there is no value to check for. I think a massive if then could work but this list will grow with time and needs to check the entire data for matches.
I hope i explained this well enough so someone might lead me to a solution.
Thanks in advance.
Any help will be appreciated.
My first Tab sheet looks like this:
A | B | C | D | E | F | G |
Date | Charged | Vendor | to Charge | Description of Item(s) Purchased | Use of Item(s) Purchased | On Statement |
1/20/2014 | $ 53.89 | PDQ | 25 | Fuel | ||
1/20/2014 | $ 53.86 | Hays 24/7 | 25 | Fuel | ||
1/20/2014 | $ 47.84 | Valero #4074 | 24 | Fuel | ||
1/21/2014 | $ 97.07 | Quality Inn | 25 | Lodging | ||
1/21/2014 | $ 46.71 | Home Depot | 22 | Misc | ||
1/22/2014 | $ 86.12 | Quality Inn | 21 | Lodging | ||
1/22/2014 | $ 60.34 | Craig Conoco | 25 | Fuel | ||
1/23/2014 | $ 81.66 | Sleep Inn | 25 | Lodging | ||
1/23/2014 | $ 55.07 | Davis Bros Service | 24 | Fuel | ||
1/23/2014 | $ 49.43 | Pilot # 903 | 22 | Fuel | ||
1/24/2014 | $ 81.50 | Quality Inn | 24 | Lodging | ||
1/28/2014 | $ 50.49 | Caseys General | 25 | Fuel | ||
1/30/2014 | $ 52.80 | EZ GO 71 | 25 | Fuel | ||
1/30/2014 | $ 107.14 | Jiffy Lube | 25 | Misc |
<tbody>
</tbody>
My Second Tab looks like this:
A | B | C | D | E | F | G |
Originating Account Number | Posting Date | Trans Date | Type | Description | Expense Category | Amount |
xxxx-xxxx-xxxx-2096 | 1/13/2014 | 1/9/2014 | Debit | Hotel | Travel | $81.50 |
xxxx-xxxx-xxxx-2096 | 1/14/2014 | 1/13/2014 | Debit | Fuel | Auto Related | $56.06 |
xxxx-xxxx-xxxx-2096 | 1/16/2014 | 1/15/2014 | Debit | Fuel | Auto Related | $52.59 |
xxxx-xxxx-xxxx-2096 | 1/22/2014 | 1/20/2014 | Debit | Fuel | Auto Related | $53.89 |
xxxx-xxxx-xxxx-2096 | 1/22/2014 | 1/20/2014 | Debit | Fuel | Auto Related | $53.86 |
xxxx-xxxx-xxxx-2096 | 1/22/2014 | 1/20/2014 | Debit | Fuel | Auto Related | $47.84 |
xxxx-xxxx-xxxx-2096 | 1/23/2014 | 1/21/2014 | Debit | Home Depot | Home Repair | $46.71 |
xxxx-xxxx-xxxx-2096 | 1/23/2014 | 1/21/2014 | Debit | Hotel | Travel | $97.07 |
xxxx-xxxx-xxxx-2096 | 1/23/2014 | 1/22/2014 | Debit | Fuel | Auto Related | $60.34 |
xxxx-xxxx-xxxx-2096 | 1/24/2014 | 1/22/2014 | Debit | Hotel | Travel | $86.12 |
xxxx-xxxx-xxxx-2096 | 1/24/2014 | 1/23/2014 | Debit | Fuel | Auto Related | $49.43 |
xxxx-xxxx-xxxx-2096 | 1/26/2014 | 1/23/2014 | Debit | Fuel | Auto Related | $55.07 |
xxxx-xxxx-xxxx-2096 | 1/26/2014 | 1/23/2014 | Debit | Hotel | Travel | $81.66 |
xxxx-xxxx-xxxx-2096 | 1/26/2014 | 1/24/2014 | Debit | Hotel | Travel | $81.50 |
xxxx-xxxx-xxxx-2096 | 1/30/2014 | 1/28/2014 | Debit | Fuel | Auto Related | $50.49 |
<tbody>
</tbody>
Now.. in the first TAB above in Column "G" i would like it to check if the amount in B and date in A and find that line in the second Tab in columns G (for the amount) and C (for the date).
Then if it finds a match it would let me know YES or NO in column G in the first TAB.
I have tried this with vlookup but there is no value to check for. I think a massive if then could work but this list will grow with time and needs to check the entire data for matches.
I hope i explained this well enough so someone might lead me to a solution.
Thanks in advance.
Any help will be appreciated.