Hello all
Could someone please tell me how I can create an index/match operation in Power Query, where it first looks up in one column, and if it finds a match it returns that, and if not it looks in another column. If it is blank in the first column and there is a match in second column, it should return the match from second column, not the blank.
Like this where it should add a new column where it first look in FirstFruit, and then in SecondFruit:
NewColumn.png
I tried with the Merge options, but that does not seem to do as I thought it would.
Any help will be highly appreciated
Best regards
Imbizile
Bookmarks