Excel function Return all row that in the list cell match specific key word

[chungtai56]

I wanna make return all item from a list that any cell contain specific key word. If possible in more advanced level, make the return from a range of cell instead of list of row. Thanks.