How to do a search in Excel? Complicated

Hello,

I've got a question, I just want to ask if anyone here know how to do a search in Excel but is a more complicated version. What I have is that I have a list of different names and with each name there is 4 columns and I want to be able to search it up and all those 4 columns will appear.

For example, I have,
Cell A B C D E
1 Apple 5 6 7 8
2 Boy 8 9 10 11
3 Cat 1 3 5 7

And what i want to do is that when i search for apple; not only just apple but 5 , 6, 7, 8 will also appear.

Thank you very much. Please help me ASAP. Thank you.