Excel 2016 : How to Create a Highlighting Search Box

Creating a Highlighting Search Box in Excel 2016

[ameliacasarez]

I think you just saved my job, a million thanks!!!

[guyh]

Didn't work in Excel 2016. Says it's not a valid formula.
Copied it to the letter

[gyallington]

I have my search bar above all my information at the top of my spreadsheet, is that a problem? Why does my search highlight the line ABOVE what ive searched?

[iesmartielongoria]

VIDEO HELP THANK YOU!! IS IT POSSIBLE FOR THE RESULTS TO SHOW IN OTHER SHEET?

[mikewilson]

Does it matter where you place the search box? I have mine above the column headers - Is that a problem? Thanks

[alancotterill]

Second time I've used this in two different jobs - thanks!

[oceanmultimedia]

in excel 2016 its not exact the same interface that you are working to. I am creating my formula but everytime its giving me back an error telling me that I must use " " if I want to write inside the cell. The problem is that I don't want to write in this cell I want to use it as a search box...Same thing you did on the video! Any idea???

[stanthedjman]

I know this is an old post. However I found it very helpful. However, here is my problem. I am a karaoke dj. My karaoke library is 122, 000 plus files. You video is useful but for me you would have to scroll for results. Is there a way to go to the highlighted data on the spreadsheet?

[clemwolff]

its working, how do i set up the formula to go to a specific cell, instead of scrolling down and searching for it.

[tupera]

While this works, I want to know how to make the default Excel find feature highlight a cell better. When you use the Excel find and it locates a cell, it's very hard to know what cell it's highlighted visually...is there a way to make that better?

[waltermakuzander]

Dude, your video helped me a ton! Kudos 🤟

[mauricelee]

Very nice and useful, thanks for sharing this video to us.

[bigbabyja]

Followed to the letter and every time I type in my search all it does is add it to that cell

[MiRa-rzfm]

It's not working. It says entered too few arguments.

[johntitor]

IT IS NOT WORK.- "the formula has error"

[drshepherd]

this is such a messed up scenario and probably wont work if you have not the same language installed or the exact version he is using.

[Suzukii-DIY]

Thanks this formula worked. I found out that at 1st it wasn't working due to my own clumsy mistakes. I was (.|.) close to giving you a thumbs down.
(phew)