Need help creating search function of list

Hi everyone! I am new to this forum. I would really appreciate your help!

See below for my example (comments further help to explain what I am trying to do; link to image also at very bottom). I am trying to program a search function in F4. When a user inputs a last name into this cell, the formulas (starting in F6 and continuing downward) should read the cells in C5 downward. Each time the last name matches, the list on right will display the project name the person is working on (i.e. what corresponds in column B).

This is to help me keep track of projects we have assigned to various people, and to see what projects people are working on. Again, would really appreciate your help.

Lastly, I want to do this without using VBA.

THANK YOU!

Example.jpg

romeogbs19,

Welcome to the forum!
Is there any reason you wouldn't just use the filter you have on your headers? Click the filter drop-down, use the "Text Filters" -> "Contains" option

The reason that won't work is because he needs "*Jordan" and "Jordan*" entries to appear.
If you could post what you have in excel form a simple vlookup using wildcards and helper columns should work.

Melvin, The Text Filters -> Contains will show all entries with Jordan, regardless of other text in the cell.

Attached is an example workbook showing both solutions. The first sheet is called 'Filter Solution' and shows what the filter looks like after using "Text Filter" -> "Contains" -> Type "Jordan" -> OK

Then second sheet is called 'Formula Solution' and is a mirror of the picture shown in the original post.
In that sheet, cell F6 and copied down to cell F22 is this formula:

Please Login or Register  to view this content.

I still believe there's no reason to use the formula solution though.

My mistake.
I couldn't access my excel, and was making an educated guess.

If you include a "Space" prior, it should take care of that (ex. " Dan" instead of "Dan").

It should work. I just tested with this simple example:

Please Login or Register  to view this content.

If you filter for dan then both are coming up. If filter for space before dan (e.g. " dan" instead of "dan" without the quotation marks) then only the second is shown.

abousetta

P.S. Also can you please modify your title by removing " HELP! Need help " as this does not add anything to your title. Thanks.

romeogbs19,

Can you post an example workbook that is experiencing the issue?

In this case you can use the advanced options for the filter by clicking on "Text Filters" >>

Please Login or Register  to view this content.

without the quotes.

Using the exammple workbook I provided, you can adjust the formula in cell F6 to the following, and then copy down:

Please Login or Register  to view this content.