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.
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.