The FILTER function extracts every matching record while XLOOKUP only returns the first result.

For many Americans, installing a heat pump to heat and cool a home can lower household bills in addition to reducing emissions. But in some places, that financial advantage has a big weak spot: winter ...