I have previously found a page where it showed how to set up so that when you start typing in a cell that it will search/rank/count etc. the results eg.

I start typing in cell "AP" and it will search a list on another page and show all options that have "AP" in it eg. apple apricot...

can some one help?