Jul 26 2022 06:35 AM
Jul 26 2022 07:50 AM
You can try these formulas which seem to work in my sheet.
With Office365 or 2021 you can apply XLOOKUP as well.
Jul 26 2022 08:36 AM
@Quadruple_Pawn Thank you for the answer but it still doesn't work for me.
Jul 26 2022 10:18 AM
Does it work when you open the attached file?