LOOKUPVALUE with multiple results

thanks Ashish for getting back to me so fast, please see in  link below an xls sheet with table 1, table 2 and the desired result table.

What I want to accomplish is to get power bi to create a new table using table 1 and table 2 with the common column "sector", so basically expand table 1 with table 2.

I think that's exactly what your code is supposed to do but I think I'm doing something wrong - unfortunately I'm new to BI and still need to learn 😉

Thank you so much.

link to file