Creating a search engine for returning contact directory

[Scorpion Steve]

 

[Scorpion Steve]

 

[Scorpion Steve]

Ok, Ive tried to upload an image again but its still not showing!

I am looking to discover a way of searching a database of contact details but typing in a name.

I need to have a list produced with the relevant details attached.
This also needs to return multiple data.
E.g.
A1 TO d1 are the headers NAME SURNAME SITE CONTACT.NUMBER
Then, obviously a list of details would be under all the above.

Now, I would like to type in a name (in cell .. say f1) and have a list of data fill in under the headers which are duplicated from the data array to the search results page.

If there is more than one name existing, I need more than one result displayed.

Please Help? :/
P.s.. I understand vlookup/hlookup and IF functions etc etc

 

[T. Valko]

Ok, Ive tried to upload an image again but its still not showing!

I am looking to discover a way of searching a database of contact details but typing in a name.

I need to have a list produced with the relevant details attached.
This also needs to return multiple data.
E.g.
A1 TO d1 are the headers NAME SURNAME SITE CONTACT.NUMBER
Then, obviously a list of details would be under all the above.

Now, I would like to type in a name (in cell .. say f1) and have a list of data fill in under the headers which are duplicated from the data array to the search results page.

If there is more than one name existing, I need more than one result displayed.

Please Help? :/
P.s.. I understand vlookup/hlookup and IF functions etc etc

Wouldn't a VLOOKUP work?

http://contextures.com/xlFunctions02.html