Search Box In Excel 2007

**jordan682** · 04-21-2013, 05:24 AM

Hi there,

I am wanting to make a search box in excel but don't have a clue how to do it, I have 3 rows of data in sheet 1 and am wanting to make a search box and be able to type anything in and pull information out of the 3 rows and into a results.

So if I type only a part of something in it will show everything that contains that.
Can anyone help me?> I have watched the videos on youtube but they are quite confusing!

Thanks
Jordan

**Harribone** · 04-21-2013, 05:54 AM

Wat are you searching through? All 3 rows? or just 1?
Can you upload a basic example of your sheet please and we can explain how to do this in a way that relates to your needs. Can you include an example search with results typed in manually please so we know where the results should appear.

To upload click Go Advanced at the bottom right of the reply box. Then select Manage Attachments.

**jordan682** · 04-21-2013, 06:19 AM

Thank you for your reply, I have made an example and attached to this post, I am wanting to search all 3 rows of the information and be able to see the results on sheet2. Hope this helps.

Thanks
Jordan