richmcgill
Board Regular
- Joined
- Feb 4, 2019
- Messages
- 71
- Office Version
- 2016
- Platform
- Windows
I have two tabs. The first tab has a list of numbers numbers with dates. The second tab has the same loan numbers but has amounts with the account number.
I know a VLOOKUP will work here but my boss is wanting a formula. I know a pivot table will work.
So if I had a cell with a date and can change at will for this instance 06/01/2019 make the the column populate with the account numbers and the amounts with the account number. I only want the accounts (not a count) that match the date and populate the amounts on the other tab.
What would this formula look like?
<colgroup><col><col></colgroup><tbody>
</tbody>
Second Tab
<colgroup><col><col></colgroup><tbody>
</tbody>
I know a VLOOKUP will work here but my boss is wanting a formula. I know a pivot table will work.
So if I had a cell with a date and can change at will for this instance 06/01/2019 make the the column populate with the account numbers and the amounts with the account number. I only want the accounts (not a count) that match the date and populate the amounts on the other tab.
What would this formula look like?
First Tab Loan Number | Paid Date |
1233 | 6/1/2019 |
2129 | 6/1/2019 |
3025 | 6/1/2019 |
3921 | 8/1/2019 |
4817 | 6/1/2019 |
5713 | 6/1/2019 |
6609 | 7/1/2019 |
7505 | 6/1/2019 |
8401 | 6/1/2019 |
9297 | 6/1/2019 |
10193 | 6/1/2019 |
11089 | 6/1/2019 |
<colgroup><col><col></colgroup><tbody>
</tbody>
Second Tab
Loan No | Compare Interest |
1233 | 0 |
2129 | 0 |
3025 | 0 |
3921 | 0 |
4817 | 0 |
5713 | 0 |
6609 | -694.17 |
7505 | 0 |
8401 | -691.04 |
9297 | 0 |
10193 | 0 |
11089 | -630.2 |
1233 | -617.61 |
2129 | 0 |
3025 | 0 |
3921 | -601.83 |
4817 | 0 |
5713 | -572.33 |
6609 | 0 |
7505 | 0 |
8401 | 0 |
9297 | 0 |
10193 | 0 |
11089 | 0 |
<colgroup><col><col></colgroup><tbody>
</tbody>