I have a spreadsheet with financial info. The data is unsorted (for example, not by the date when I sent a check, but in the order that it was processed) and the balance. I want to find out the approximate balance on a particular day, for example:
| jan 1 | $2000 |
| jan 3 | $5000 |
| jan 6 | $8000 |
| jan 4 | $4000 |
In this example, if I want to find the value for january 5, it would go through, find a value for january 5 or earlier, and return the balance on that date; in the example above, the value for jan 4. vlookup, index, match don’t quite seem to do what I want. Is there a way to do this?