Forum Discussion
TRICKY - Power Query Lookup
Hi, Anonymous
In my opinion, I think you can try to use the merge query function.
Please check the below for the merge query function in Power Query Editor.
1 Select the table that you want to pull data into.
2 click
3 select the table that you want to lookup the value
4 select the column that you want to match
5 select the column that you want to match -> in step four, when you select multiple columns the numbers are shown. you also have to match these numbers with step five.
6 click
I hope it helps.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster.
Hi, Anonymous
In my opinion, I think you can try to use the merge query function.
Please check the below for the merge query function in Power Query Editor.
1 Select the table that you want to pull data into.
2 click
3 select the table that you want to lookup the value
4 select the column that you want to match
5 select the column that you want to match -> in step four, when you select multiple columns the numbers are shown. you also have to match these numbers with step five.
6 click
I hope it helps.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster.