Create a list from Table

[sqrcbc]

Hi all,

so i managed to enter data to a database via a form. actually works like a charm.

Now, what i Need, is a lookup function (preferrably not a form), with which i can search a table on another worksheet.

Lets say, i got an edit field or a cell, in which i enter a term which shall be looked for in a certain column on the table in another worksheet. I would like to get a list of all entries which contain the word and the Value from another cell (an ID).

Example:

Search term:

Please Login or Register  to view this content.

Table:

Please Login or Register  to view this content.

The List should Show Tom and Tommy and their respective IDs. But evrything i tried didnt turn out as intended (mostly didnt work at all)... I suck at this :D

[JeteMc]

The attached file employs the following array entered formula* to look up the names found in the table on sheet1:

Please Login or Register  to view this content.

The following formula then looks up the ID:

Please Login or Register  to view this content.

*Array entered formulas are confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Let us know if you have any questions