March 19, 2026•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

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

Check out the full article on the original site

#Excel compatibility

#Excel alternatives for data analysis

#Excel alternatives

#rows.com

#cloud-based spreadsheet applications

#AI formula generation techniques

#formula generator

#row zero

#Power Query

#Excel

#formula

#column number

#result

#index

#match

#offset

#reference

#efficiency

#function

#let