https://www.automateexcel.com/formulas/xlookup-duplicate-values/
XLOOKUP Duplicate Values - Automate Excel
Jul 30, 2023 - This tutorial will demonstrate how to XLOOKUP duplicate values in Excel. If your version of Excel does not support XLOOKUP, read how to use the VLOOKUP
xlookup duplicate valuesautomateexcel