Power query formula to replace INDEX - MATCH|Power Query|Excel Forum|My Online Training Hub

Hi,

I am trying something what I think should be an easy formula in Power Query, but I don’t find it 

This is the normal excel formula in cel S2 of sheet “CHK_IC_INV_01”

=IFERROR(INDEX(J:J;MATCH(A2&"/CI";R:R;FALSE));"No CI partner")

It does the following : check for value on each row in Column A combined with “/CI” in full column R (not specific on same row)

e.g. 8123200828/CI

if found : value column J, if not found, “No CI partner”

Hope you can help me? Adding this formula in Query “Invoices” will allow me to further clean up

Kind regards,

Claudine