Today, November 3, 2019, the function arguments for XLOOKUP changed. The if_not_found argument moved from 6th to 5th. That means any old XLOOKUP functions that used arguments 4, 5, or 6 might break at the next Recalc.
Today, November 3, 2019, the function arguments for XLOOKUP changed. The if_not_found argument moved from 6th to 5th. That means any old XLOOKUP functions that used arguments 4, 5, or 6 might break at the next Recalc.