Forum Discussion
Power Query searching for text between 2 columns
Hi all, 2 part question, hopefully pretty simple. I have 2 tables, I'm trying to search a column in 1 table for values in a column on a second table. I want it to return the matched value when ...
Just use List.First instead of Text.Combine (and delete the , ",")
Regards,
Pat
I figured out why it's hit and miss....which leads me to a newcomer question... how would I make that code so it isn't case sensitive?
On the Transform tab under Format, you can UPPER or lower case one or both columns.
Regards,
Pat