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!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.