Forum Discussion
llamasarefun
Helper I
Helper Ilookup 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!
llamasarefunHelper I
Helper IAlienSx yes sorry my mistake!
So no errors now but I cannot see where the new column where i would see the results is?
AlienSx
Super User
Super Userllamasarefun rightmost column called "YN", located after column CR LOOKUP VALUE
- AlienSx
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
- llamasarefun
AlienSx there is no additional column, CR LOOKUP VALUE is the last one still
- AlienSx
- llamasarefun
- llamasarefun
AlienSx Brilliant, that has worked perfectly, thanks so much for your help!