Forum Discussion
Golfnhockey12
Apr 25, 2020Copper Contributor
Keywords in one column to populate another
I have a file we’re in one column is have a description, I want to make a formula to look at that column for keywords which populates another column from a key.
Golfnhockey12
Apr 28, 2020Copper Contributor
Correct, right now I have three, which each one corresponds to a vendor.
Wyn Hopkins
Apr 28, 2020MVP
This video shows how to do this type of thing using Excel's Power Query
- Zack BarresseApr 29, 2020Iron Contributor
Wyn Hopkins that's a very clever method!