Forum Discussion
Solved
lookup value in another column
hi, I am trying to lookup a value from one column to see if it exists in another column and then return either a yes or no. Can this be done easily in power query? thanks
1. Create blank query
2. Open Advanced Editor
3. Replace everything you see there with my code
4. Replace your_table with MASTER in the code
AlienSx Brilliant, that has worked perfectly, thanks so much for your help!
llamasarefun rightmost column called "YN", located after column CR LOOKUP VALUE