Oct 17 2021 08:00 PM
Oct 17 2021 08:37 PM - edited Oct 17 2021 08:42 PM
Solution@Getwiser Created a simplified example in the attached file. Since you considered using XLOOKUP, I suspect you are on a modern Excel version. Then you can use FILTER to achieve what you want. See attached.
Oct 17 2021 09:12 PM
Oct 17 2021 08:37 PM - edited Oct 17 2021 08:42 PM
Solution@Getwiser Created a simplified example in the attached file. Since you considered using XLOOKUP, I suspect you are on a modern Excel version. Then you can use FILTER to achieve what you want. See attached.