Lookup Value from different Rows - Power Query

OmarAl · ‎05-01-2024

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

v-yangliu-msft · ‎05-01-2024

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 · ‎05-01-2024

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