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
| +435 | Is UBS really that bad? | 79 | 20m |
| +265 | Investment Banking is Divine | 40 | 2d |
| +225 | Another $115bn Mega deal for these banks. Congrats! | 46 | 22h |
| +216 | US 2027 SA IB worried about background check | 53 | 2d |
| +126 | Which Offer to Accept: UBS Analyst Role or Part Time Cashier at the Local Taco Bell | 30 | 5m |
| +81 | Useless associates | 15 | 6h |
| +64 | Roku-Fox Deal - UBS Misses Out on yet another deals after years chasing this deal | 17 | 2h |
| +52 | Differences in Restructuring Teams? | 24 | 18h |
| +48 | FIG Pigeonholes you - is it true? | 19 | 1h |
| +41 | Is Houston SA 28 recruiting already over? | 34 | 2d |
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
Itaque veritatis veniam quae odio sit beatae. Qui et molestiae culpa voluptatem dolorum occaecati quia. Qui qui cumque et voluptatem reprehenderit ut.
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...