How to do a search in Excel? Complicated

Closed
Report
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
-
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.

1 reply

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
Hi HTFB,

Have you heard of excel's autofilter?
First insert a row before your first row (because you don't have a header row).
Goto top menu's > data > filter > autofilter.
Select the dropdown list in cell A1.
Select Apple, see the result and report back if you are happy.

Best regards,
Trowa