Forum Discussion
Translate index match in Excel Power Query
Hi! It is too heavy for Excel to execute the function =index(a:a, match(true, exact(b2, c:c), 0)) for +800 rows. I thus want to do this via Power Query in Excel instead (I loaded the data using g...
Hi TestssonNow,
You can achieve this through a self-merge
And subsequently expanding/Extracting "Column1" from the result table.
I hope this is helpful