I have created an investment spreadsheet. In one column I have the ending balance each year. In another column I have the years.
A B
2000 500K
2001 450K
2003 1.2M
2004 1.5M
How can I display the year I hit a certain arbitrary threshold (say $1M) in a single cell somewhere else on the sheet (say E32), without knowing how long it may take to reach the amount?