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...
Will there only be a single match? Or might there be multiple matches?
Also, why would you expect Text 3 as a result? Your formula in Excel would return Text 1.