You are probably doing an approximate match which is the default. Always add FALSE as the last argument.
Nope, 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.
vlookup is usually not the right tool for the job (index + match better)
Or xlookup if you are younger.
Man i just want to be able to use js instead of excels crappy meta dsl