3 ms·
Now, just to make Excel formulas actually work consistently and we’ll be all set. VLOOKUP doesn’t even work correctly about half of the time.
by bugglebeetle 3y ago
Now, just to make Excel formulas actually work consistently and we’ll be all set. VLOOKUP doesn’t even work correctly about half of the time.
- mhh__ 3y agovlookup is usually not the right tool for the job (index + match better)
- cm2187 3y agoOr xlookup if you are younger.
- cm2187 3y agoYou are probably doing an approximate match which is the default. Always add FALSE as the last argument.
- bugglebeetle 3y agoNope, I know about that. It’s just garbage software, especially their Mac version. See also the inability to open a CSV file correctly without corrupting it, unless you use a specialized import.
- bythreads 3y agoMan i just want to be able to use js instead of excels crappy meta dsl
- deleted 3y ago[deleted]