Forum Discussion
excel function question
1. I have a list of codes and would like to generate a list of codes that are in Column A from Sheet 1 and not in column A of Sheet2 and return the value in column B from Sheet 1 of the codes that p...
kmb06002 , that could be done with Power Query. 3 steps
- query first table
- query second table
- merge first table with second one with Left Anti and land the resulting table with values from first table for which codes are not in second one.