A little from column A, a little from column B: XLOOKUP is the new, easier way to retrieve information across Excel spreadsheets.

Excel's AGGREGATE function lets you perform calculations whilst ignoring hidden rows, errors, or other functions that appear in the data. It's similar to the SUBTOTAL function but provides more ...