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...
TestssonNow thank you for your post, and leveraging Power Query to handle this for which it is aptly able. m_dekorte is a rockstar, and her crazy wonderful work and warm gentle touch with folks on solutions is quite a gift. You are in good hands. Thank you!