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