Forum Discussion
lookup value in another column
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!
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.
llamasarefun my code does not have such "name".
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 yes sorry my mistake!
So no errors now but I cannot see where the new column where i would see the results is?
llamasarefun rightmost column called "YN", located after column CR LOOKUP VALUE
AlienSx there is no additional column, CR LOOKUP VALUE is the last one still
AlienSx Brilliant, that has worked perfectly, thanks so much for your help!