LOOKUPVALUE

[butterscotch]

Hello everyone!

im facing an issue with LOOKUPVALUE , where it only return the first matching value but i have multiple data (project)

this is the 1st table:

this is the 2nd table:

this is the expected output: 

Can anyone help me ? thank you in advance!

[PijushRoy]

Hi @butterscotch 

In Power Query editor, Marge table as new and use join kind Full Outer (all data from both table)

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

[butterscotch]

this is the result when i merge both tables 

as you can see, the table only retrieve the 1st value from norm , if and only if the merging action allow me to select 2 columns that can be used to match these values

[Daniel29195 · Accepted solution]

@butterscotch 

in merge queries, you can merge on multiple columns.

just click CTRL  btton while selecting the columns you want to merge on,

hope this helps. 

[butterscotch]

@Daniel29195 , omg it works ! thank you so much !