Forum Discussion
Solved
LookUp In PowerQuery
I have a column that looks at the responses students have given to the question ' What is your discipline?' Each numeric value is is a discipline. E.g. 56 = Medicine, 115 = Dentistry etc. ...
You could just use the Merge menu to do a Nested Left Outer Join on Index = Key, and then expand just the Disciplines text column.
--Nate
From your original post - "Each numeric value is is a discipline. E.g. 56 = Medicine, 115 = Dentistry " so you want to merge on Q33-discipline and key
