Forum Discussion
Power Query Vlookup Dynamic Column Reference
I have a query where Column "INDEX" values are the header names of other columns. I want to return the matching value. How can i do this in Power Query? Its basically a Vlookup with a dynamic col_ind...
In query on second table select KEY column, Unpivot other columns and add column with combined index. In query on first table create same combined index (KEY & "any text/symbol which is definitely not in your names" & INDEX), merge on it with second table and expand values only.
Please check attached.