Array formulas in Excel, thank you...

Was trying to do a dynamic search for text within a range of Excel rows. Array formulas to the rescue. Great examples here:
emailoffice.com article

Be sure to hit "ctrl+shift+enter" when done entering the formulas or it won't work.