How to adjust Index to catch duplicate entries?

Good morning, I have the attached excel sheet that works okay... a few issues I ran into is in some cases the name will be blank but will have data in the other fields but when that option is selected nothing comes up.

Also if there happens to be more than one Jane I would like for all records with the Jane to appear... in some cases I will have up to 20.

Try this formula instead in B7:

=IFERROR(INDEX($J$11:$L$16,SMALL(IF($J$11:$J$16=INDEX($M$3:$M$7,$O$1),ROW($J$11:$J$16)-ROW($J$11)+1),ROWS(B$7:B7)),COLUMNS($A$1:A$1)),"")

confirmed with CTRL+SHIFT+ENTER not just ENTER, then copy across and down

to hide 0's, format B7:D8 as Custom with Type: 0;-0;;@

The date column format would be: m/d/yyyy;-0;;@

Hi there

1 way is using this ARRAY formula in B7. Copy down and across.

Formula:

Please Login or Register  to view this content.

I've used a separate data vaidation for your list in cell B2

This is an array formula so entered woth Ctrl Shift Enter

jgomezv1.xlsx

You are welcome and thanks for the feed back.