When “Equals” Doesn’t Really “Equal” in a Spreadsheet

Here’s how I solved a problem in a complex spreadsheet that was both very difficult yet simple to find.