B bosco_yip Excel Ninja Feb 6, 2020 #2 Basically it can be done, please upload a file with example data and expected result. Regards
P Peter Bartholomew Well-Known Member Feb 7, 2020 #3 It will be more common with XLOOKUP because that function returns entire arrays, like INDEX/MATCH, making a second 'orthogonal' search more relevant.
It will be more common with XLOOKUP because that function returns entire arrays, like INDEX/MATCH, making a second 'orthogonal' search more relevant.