@WalrustheCat the macOS version of less is from 2013, specifically version 458. The current Homebrew version is 487. Some enhancements have been made and bugs have been fixed between versions.

The latest Homebrew llvm (3.9.1) in the homebrew-core tap now includes clang, clang++, etc. under /usr/local/opt/llvm/bin

@LinusG. glad #2 worked. It looks like you have the wrong value in the third argument to MATCH.

I'm working on a Numbers-only solution, however. Is it possible that the Address columns disagree between tables? If so, how do you want to handle it?

In fact I think the most robust solution would actually be to export your spreadsheets as CSVs, import them into a database (macOS comes with a database engine called SQLite already installed), do a join in the database, and then export a CSV to re-import into Numbers.

This operation is called a "Left Join" in database lingo. I don't know if it's possible directly in Numbers, but maybe at least knowing the term can help you search better.

I'm baffled by the comments here. "This came from Git" does not mean "this error message is normal." Can someone confirm that this is in fact the expected behavior of XCode when creating an App? If so it sounds like a bug.