Danger: Beware Vlookup Defaults [in Microsoft Excel]

OP here: I'm curious, do anyone know if the VLookup defaults make sense in any kind of way? I was first shocked when I realized this behaviour of VLookup, but then I was thinking that there was perhaps a good (although unclear) reason for it?