Forum Discussion
Vlookup - in one table based on 3 columns
On my monthly update with thousands of lines from the raw data list I need to replace in Power Query [External Tx ID] "rexxxxxx" (based on "refund" in [Tx Type] column) with "pixxxxxx" (based on orig...
Hi, thank you for the quick reply. Very much appreciated.
I might do something wrong because I see on your tab it should work, but not for me for some reason, showing error - snapshot below.