3 ms·
I know the IDE has tooltips, but why don’t they ‘invent’ enums instead of those magic constants for match_mode and search_mode? Does that complicate the parser
by Someone 7y ago
I know the IDE has tooltips, but why don’t they ‘invent’ enums instead of those magic constants for match_mode and search_mode? Does that complicate the parser that much?
For VLOOKUP and HLOOKUP, they can’t for backwards compatibility, but this breaks new ground.
- make3 7y agothey likely either made utility studies for this, or all of Excel already works that way and they don't want to break the expectations of the users