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.
| +186 | Americas M&A League Table Q2 Updated | 75 | 3h |
| +135 | New Article: Dramatic Slide as UBS #22 (US) & New Leadership Desperately Needed | 28 | 2h |
| +115 | Restructuring: Anti-climactic Experience | 30 | 3h |
| +85 | IB Net Worth / Savings Check | 35 | 5m |
| +75 | A COMPLETE GUIDE TO SUMMER INTERNSHIP RECRUITING | 12 | 2d |
| +51 | Boutique firm wants access to my LinkedIn? | 40 | 1d |
| +39 | Investment Banking is Hard | 17 | 1d |
| +34 | Woman who emptied Knicks trashcan on street then stole it was DEI exec, worked at JPMorgan Chase | 10 | 5h |
| +31 | PWP vs BofA | 23 | 11h |
| +27 | Who pays the highest right now? | 14 | 11h |
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.
Et animi consectetur dolorem quasi minima omnis. Itaque ut ab aut tempora ab ut repellat. Laboriosam officia quis voluptas voluptatem alias occaecati.
Odit sunt earum amet autem ipsa unde. Soluta reiciendis dolore quibusdam sapiente officia. Eligendi veniam aspernatur consectetur et excepturi accusamus recusandae.
Ipsa inventore voluptates est reiciendis quis corporis neque rerum. Qui earum quod aliquid minima temporibus. Consequuntur sit molestiae earum dolore eum. Sed natus facere autem libero reprehenderit laborum consectetur ut. Expedita veniam rerum enim libero recusandae et.
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...