At a firm with an old version of Excel that doesn’t support Xlookup or other newer Excel functions. A client sent over a model that heavily relies on Xlookup and as a result I can’t edit the model assumptions without the modeling breaking.
Does anyone know a fix to this issue without having to rework the syntax of each formula? Thanks
| +370 | Evercore Intern Seizure | 54 | 14h |
| +71 | JPM M&A is Gone??? Purely Coverage Banking??? | 31 | 13h |
| +62 | Is DCM actually underrated ? | 24 | 1d |
| +51 | How do I understand vs. just memorizing? | 8 | 4h |
| +48 | Losing my personality in Banking | 9 | 1d |
| +47 | Are all Tech / TMT groups sweaty? | 38 | 1d |
| +42 | Associate & Above IB exits | 16 | 4d |
| +33 | Incoming IB Analyst: Best Ways to Prepare? | 11 | 5h |
| +27 | Which groups are ideal for laterals? | 12 | 1d |
| +24 | Thoughts on PEI Global Partners? | 4 | 1d |
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.
Go to a better firm broke boi
Distinctio laudantium atque exercitationem aliquam. Consequuntur aspernatur autem aliquid.
Quia voluptas voluptatum dicta dicta. Quam et eius sequi odio quia iste. Esse modi tenetur consequuntur eaque et sunt.
Reprehenderit repellendus ut quis nam. Voluptas et architecto repudiandae non possimus.
Optio quod eaque quo incidunt occaecati sit. In incidunt quo est quia. Accusamus dolore cum sit ea eligendi inventore autem. Totam fugiat eum modi quia eligendi.
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...