Monday, June 5, 2023

Key Word Search to Bring Back Multiple Results

Do you create dashboards or templates and want to have a mini search bar or search cell...Something like a mini google in your Excel sheet? Imagine having a cell where you can type some keyword or part of a word and expect it to bring back records that match the keyword. It’s not a full fledge search engine, but it is a neat thing you can do with just a few combinations of the newish dynamic array functions in the latest versions of Excel. Having a keyword search capability and using it for lookups is just another cool way you can use Excel to help you make spreadsheet data useful. Whether you’re doing it for yourself or have a template to send your users, think of this as a neat little tool that hopefully make your job easier.

No comments:

Post a Comment