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
@OliverScheurich Thank you for the answer but it still doesn't work for me. :( Also, my Table 1 is the bigger one (on the right side), I think there is a catch.
Jul 26 2022 10:18 AM
Does it work when you open the attached file?