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.
Monday, June 5, 2023
Monday, May 29, 2023
Lookup to Find Multiple Matches
If you’ve done lookups with VLOOKUP, INDEX/MATCH or even the new XLOOKUP, it usually just brings back one record or one match per cell. But what if you wanted a lookup to find multiple matches? Think you’d have to write crazy long formulas or VBA code?
Well with a neat dynamic array function in M365, it’s just a simple combination with other functions that will take you less than a couple minutes to put together...maybe even less that one minute, once you understand how it’s done.
Monday, May 22, 2023
Searchable Dropdown List - 2 Examples
Do you create dashboards or template files for others. Want to add some pizzazz and interactivity? Why not create a searchable dropdown list?
You can then use this feature to perform lookups or change the appearance of data in your charts or graphs. You can make it look “cool” for your user and it’s not that hard to do.
If you’re putting together a file that has gives users the ability to interact, why not let them also search for data that brings back results?
Subscribe to:
Posts (Atom)