Anyone who does serious work in Excel uses INDEX/MATCH over VLOOKUP because VLOOKUP is pretty much worthless. INDEX/MATCH is the standard best practice for data indexing.

So...an extra 5 seconds? VLOOKUP requires data to be ordered a certain way, prevents you from reshaping your data at all, is (when dealing with larger spreadsheets) slower, can’t be used in arrays, and has a limited approximate match. I’ll gladly spend 5 extra seconds.

Tell me about it.

1 - The odds of dying from measles, mumps, or rubella are in no way insignificant. Even if you don’t die, the risk of infertility or severe disability is extremely pronounced. https://en.wikipedia.org/wiki/MMR_vacci…

Please don’t use VLOOKUP. The standard best practice is INDEX(array,MATCH(lookup_value,lookup_array,0))

“I can’t imagine people would go out and buy the Fire Stick rather than just learn to live without Amazon Video.”

Not a software bug per se, but I’ve noticed a really annoying issue regarding remote access. On Windows and pre-10.11 OSX, you could boot the computer, then login via Teamviewer/VNC (or SSH for command line access) and login to the local account and use the computer. Now, I can’t connect via Teamviewer or the native…