Neat stuff on Microsoft Excel, PowerPoint and maybe some random stuff
Pages
▼
Thursday, April 9, 2020
Keyword Search in Two Columns with Power Query
If you have user that want you make an easier keyword lookup for a table of records, you could tell them to just filter the table or put some lookup formula (like VLOOKUP) together for them. But if they just want some easy to use field where they type up something and click here to get the results, maybe another solution would be to use Power Query. But remember to tell them that this is a case sensitive keyword search!
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.