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...