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.
| +268 | UBS Layoffs (October 2026) | 84 | 22m |
| +121 | Do people still want to go PE? | 36 | 17h |
| +98 | UBS Tech layoff | 37 | 10m |
| +36 | Lazard hirevue | 11 | 2d |
| +36 | What Differentiates the Best Analysts as AI Improves? | 9 | 2d |
| +33 | How do YOU manage networking requests? | 7 | 3h |
| +31 | Quitting After First 4 months | 10 | 1d |
| +27 | MBB Pay Raises | 12 | 41m |
| +25 | Cornell Club T10 Rankings (UPDATED 10/2026) | 16 | 12h |
| +25 | Are target prospects getting dumber? | 11 | 14h |
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.
Sit occaecati architecto aut hic. Ullam saepe aperiam veritatis provident hic esse nemo eius. Eos temporibus distinctio mollitia animi soluta consequatur voluptatibus.
Libero delectus a sint ducimus dolor commodi architecto. Rerum in ipsa natus non. Dolores officiis sunt delectus nihil non rerum quia. Impedit vel ab voluptate voluptas inventore. Veritatis consectetur et quisquam ad consectetur. Tenetur ullam ad soluta asperiores voluptates necessitatibus accusamus accusantium.
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...