Search Function or VLOOKUP

Hi All, i'm trying to create a function in a spreadsheet and not sure on the best way to do it:

I have a list which contains some data on sheet 1. On sheet 2, I want to create a search box that looks at the data on sheet 1, once ive search for it and clicked on the item I want, I want it to copy that row of data onto sheet 2 below the search box into a 'selected print area' then have the option to clear the search bar and search for another item. I could end up with as many as 10 line of data on my 'printable area'.

I hope somebody can help and point me in the right direction.


TIA

Hopefully that's attached, you will see that there is a formula on sheet 2 which affects the data on sheet 1.

Hope that makes sense, thanks for the help.

Thanks Glenn, that was another way I was thinking of doing it however my list will and could eventually contain over 100 items and that's a lot to scroll through to find the right one, hence why I'm trying to use a search function where if I type in 'Martin' I get all those options narrowed down.. Can I do this while using the drop down lists?

Just looking at this again, ive managed to do the searchable dropdown box, as per the link you sent me. Next question is how do I once ive searched for an item and clicked on it and it has pasted into the selected cell, how do I clear the searchbox and the next item I search for adds to the box below and so on and so forth?

Can I do this or do I have to create a searchable drop down list for each row of text?