Forum

Including the solution file, with power queries. Beth

THANKS ADAM! This worked on my test data, and lets me pull in any of the columns I need from the reference table. I have some fairly large data set...

Sure. See attached. I also included typical SQL I would use if the data were in SQL Server... I meant to name my tables for you, but now can't seem to...

Thanks Mynda. Perhaps something was held in memory, or hidden from my view (I am new, and learning my way around!), but it appears to work now with...