Forum Discussion

llamasarefun's avatar
llamasarefun
Icon for Helper I rankHelper I
2 years ago
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
Need Help
  • AlienSx's avatar
    AlienSx
    2 years ago

    llamasarefun 

    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's avatar
    llamasarefun
    2 years ago

    AlienSx Brilliant, that has worked perfectly, thanks so much for your help!

AlienSx's avatar
AlienSx
Icon for Super User rankSuper User
2 years ago

llamasarefun don't touch "Custom column" button, it's a big mistake. Have you seen that video? Your case is #2. Anyway, create new blank query, replace everything in it with my code and replace "your_table" in my code with the name of your query (MASTER?)   

llamasarefun's avatar
llamasarefun
Icon for Helper I rankHelper I
2 years ago

Hi AlienSx  Yes I have watched the video thanks, very useful.  I am putting the code into blank query and get the error 

Expression.Error: The name 'Renamed Columns2' wasn't recognized. Make sure it's spelled correctly.