IC Matching

[shafti]

Hello, How can I match these two Intra-group balances with each other in Power Query?

[ShirinArshadnia]

Hi@shafti 

in Excell we use Vlookup and in power query you can use merge

here is an Example:

https://excelchamps.com/power-query/vlookup/

I hope it has been explained clearly.

[shafti]

Thanks Shirin for your reply - I am familiar with Vlookup in Excel and merge in Power Query. I cannot merge them as they are in the same table. I have tried to create a common code between them so they get matched but I don't know how to do it!