Hi everyone.

Is it possible to use FILTER or XLOOKUP or a new function instead of INDEX&SMALL combination to filter the desired result(s) with a shorter formula?

And how to get the column header of a cell (given) in a table with duplicate values?

Please see the attached sample.

Thank you.