Forum

Similar to Vlookup ...
 
Notifications
Clear all

Similar to Vlookup in powerquery

3 Posts
2 Users
0 Reactions
76 Views
(@ayemu7)
Posts: 197
Reputable Member
Topic starter
 

Hi Team,

I have 2 data set E9 and E10 to be reconciled.

If I do vlookup, I will have 2 sets of discrepancies in each sheet.

What can I do to get the solution as per expected result sheet.

Thank you

 
Posted : 09/10/2019 6:40 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Aye,

You can use a Power Query merge to compare two lists. See attached.

Mynda

 
Posted : 09/10/2019 7:32 am
(@ayemu7)
Posts: 197
Reputable Member
Topic starter
 

Many thanks for your help, Mynda.

Regards,

Aye

 
Posted : 10/10/2019 6:15 am
Share: