Complicated Index/match formula

[spqr85]

I need a formula to help me look up multiple entries in a spreadsheet when I search. Here is the scenario:
I have a list of dates, names, and notes on job performance.

I want to be able to select an employee's name from a drop down (can do that easily in data validation) and then have excel find the list of dates and incidents linked to that employee's entry. The sheet looks like this:

Date Name Notes
1/1/01 John Smith lkjasdlfkjadslkfj
1/1/01 Steve Smith lkjsadlfkjasdklfj
1/2/01 John Smith lkasjdlfkajsdlfkj

I want the function to be able to return (below) if I enter John Smith into a cell like this ----->
Employee name: Incident dates Notes
John Smith 1/1/01 lkjasdlfkjadslkfj
1/2/01 lkasjdlfkajsdlfkj

I have come across something like this in Excel:

=IF(ROWS($F$5:F5)<=COUNTIF($A$5:$A$15,$G$4),INDEX($B$5:$B$14,AGGREGATE(15,3,(($A$5:$A$14=$G$4)/($A$5:$A$14=$G$4)*ROW($A$5:$A$14))-ROW($A$4), ROWS($F$5:F5))),"")

If that is the way to go I will work through it- but I am not an Excel guru and can't really follow that formula...

HELP!

[Pete_UK]

It would help if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Do not try to use the Paperclip icon, as it doesn't work on this forum.

Your sample workbook should be representative of the range of data that you have, and should show clearly what results you are hoping to derive from the data.

Hope this helps.

Pete

[TW80CJ5]

A simple filtering of the data (and or custom sort) should do that for you....

[Fluff13]

How about

Excel 2013 32 bit

	A	B	C	D	E	F	G	H	I
1							John Smith	01/01/2001	test1
2	01/01/2001	John Smith	test1					01/02/2001	test3
3	01/01/2001	Steve Smith	test2
4	01/02/2001	John Smith	test3

Sheet: Doc1

In H1

Please Login or Register  to view this content.

in I1

Please Login or Register  to view this content.