Lookup Value from different Rows - Power Query

[OmarAl]

Hello everyone,

I hope you're doing great! I'm trying to look up a value in certain column and replace it with identical value in different row. Can someone please recommend how to do so? 

Whenever a PO is #/# I would like to search in Document Text for identical column and replace the #/# with the PO matching in the new found row!

Sounds a bit complicated but I tried using Custom If column, but couldn't make the lookup function properly.

Bestr regards,

Omar

[Anonymous]

Thanks for the reply from @Uzi2019 , please allow me to provide another insight: 

Hi  @OmarAl ,

Here are the steps you can follow：

1. In Power Query – Add Column – Custom Column.

2. Enter the following code .

if [PO] = "#/#" then [Document] else [Custom]

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[OmarAl]

Hi Liu, I appreciate your help! But I would really like to replace the #/# with a PO number that is in dfifferent row. In example , the first #/# would ideally be replaced by 400500600 because it's matched witht the same text of Columne Document Text in row 2

[Uzi2019]

Hi @OmarAl 
Try below post for reference

https://community.fabric.microsoft.com/t5/Developer/Lookup-value-from-another-table-if-no-match-give...

https://community.fabric.microsoft.com/t5/Power-Query/Power-Query-Lookup-to-another-table/m-p/352484...

https://community.fabric.microsoft.com/t5/Power-Query/Power-Query-Lookup/m-p/2016427

https://community.fabric.microsoft.com/t5/Power-Query/lookup-value-in-another-column/m-p/3511881#M11...

I hope above post may resolves your issue!