2 ms·
It's absolutely ridiculous that this type of functionality isn't a native part of Excel, I was doing something recently in Excel that should have been trivially
by mistermann 11y ago
It's absolutely ridiculous that this type of functionality isn't a native part of Excel, I was doing something recently in Excel that should have been trivially simple but because of the lack of obviously useful functions like a multi-column VLookup or Match function, the hoops you have to jump through are insane and brittle.
One thing I hope changes with Microsoft's seemingly new culture is this deliberate crippling of product functionality so as to not cannibalize revenues from other projects. Another good example is MS-Access - such a highly productive environment, but some fundamental shortcomings in the design make it totally unsuitable for projects beyond a certain size.