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
| +391 | Change My Mind: Banks Shouldn’t Hire Foreigners at All | 109 | 22m |
| +170 | Article - UBS’ Investment Bank Keeps Losing Ground | 34 | 2h |
| +78 | An Exhaustive Guide: How to Solve Every Single Accretion/Dilution Question | 6 | 5h |
| +51 | When to Leave Office as Intern | 5 | 2d |
| +43 | Best IB Group Overall? | 25 | 23h |
| +38 | Don’t work at UBS - UBS Sucks | 5 | 1h |
| +34 | Would you rather be a Touse Squid or a Bouse Mogger in IB | 2 | 2d |
| +31 | What do you say to ppl who don’t know EVR/LAZ/CVP/PJT | 22 | 1d |
| +31 | STEM student lost in London IB recruiting | 17 | 12h |
| +20 | Still recruiting SA'27 | 13 | 10h |
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
Natus repellendus reiciendis id provident. Ut vitae temporibus eveniet numquam. Tempora quisquam nisi excepturi voluptatibus ea atque. Illum nisi officia recusandae quibusdam.
Et fugiat sint dolor cum non facere facilis voluptates. Et culpa maxime neque consequuntur. Laudantium rerum et non fugit molestiae impedit. Qui sint aspernatur nesciunt rem.
Et ipsa ea reprehenderit repudiandae. Laborum asperiores minus ad est aut. Maiores soluta quos id sed.
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...