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
Hi Claudine,
In Power Query you use a Merge to do the equivalent of INDEX & MATCH or VLOOKUP/XLOOKUP. Your scenario isn't a straight forward merge though. See file attached.
Mynda
Indeed, this works
Thank you Mynda!
