Any excel masters here? I am trying to reference a cell in a certain way. So I am basically trying to link numbers to a certain cell. Example:
There is a cell for # of years. I input anything from 1 - 10 in this cell. I need to link each of these numbers to a cell on a different sheet.
So "1" would link to F26. "2" would be F38. "3" would be F50. etc.
Will give a banana for anyone that can help me with this. Thanks.
| +86 | Drunk VP. How to manage? | 28 | 13h |
| +44 | Lazard US Views 2026/2027 | 16 | 11h |
| +41 | Who is the final boss in Houston Energy? (GS, JEFF or EVR) | 9 | 15h |
| +37 | Tomorrow Will Be Better | 5 | 20h |
| +34 | Moelis PCA vs Lower tier BB Coverage | 21 | 28m |
| +28 | Why Do We Turn Comments? | 3 | 20h |
| +22 | UBS’s Investment Bank Is Building an AI Slop Factory | 2 | 17h |
| +21 | How early is to early? | 9 | 1d |
| +21 | [2026 - October] Unbiased Prestige Rankings | 7 | 16h |
| +20 | MS NYC Generalist Program Group Rankings & Placement Process | 11 | 22h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
What do you want to do in the linked cell?
your explanation isn't very clear but it sounds like you need CHOOSE() ?
can you upload the spreadsheet?
Ok so I will clarify, I am modeling a RE firm buying multiple properties. This firm is taking on amortizing debt. Since they will be paying down debt each year, I wanted to model out there IRR in year X vs. year Y. So I will have one cell that you can enter in the number of years. So lets say three years. Then another cell will tell you how much debt amortized over those 3 years.
never mind, I got it, thanks jec.
i am not an excle master but i think you can use pretty simple IF statements to do this.
Vitae eos quidem repellendus. Illo voluptatibus unde ea est ut. Dolore alias amet officia quia ab voluptatem ad.
Qui rerum ea error enim accusantium aut praesentium est. Quod error non cum rem modi iure fugiat. Reiciendis hic odio sed adipisci perspiciatis. Sed rerum est itaque reiciendis vel quam.
Rerum aut asperiores dolores explicabo nisi omnis. Totam maiores est porro tempore rem alias rerum. Earum dicta commodi ratione ut est ab quo.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...