•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Return Column based on a row's result in Power Query
Our take
In Power Query, you can simplify the process of returning a column based on a row's result by leveraging its powerful data transformation capabilities. While your current Excel formula efficiently retrieves a column number based on another column's result, Power Query allows for a more streamlined approach. By utilizing functions like `Table.SelectColumns` and `Table.AddColumn`, you can achieve similar outcomes with improved efficiency.
I currently have a formula in excel that returns a column number based on the result of another column, see below:
=let(x,[@Result],index(offset(otherSheet[A:A],0,x),match([@Reference],otherSheet[Reference],0)))
Probably not the most efficient way of doing it, but is there some way of doing that or something like that in Power Query
[link] [comments]
Read on the original site
Open the publisher's page for the full experience