Not sure if the title best describes what I am trying to do. I have range (A1:C13) that contains a column of names, test dates and scores. J1 contains the name that I want to search through the table and list all of their test dates (dynamic list in F:G column). From the list of test dates I have entered an Array formula that will look up their score. I also added a chart that will change with each date entered. (It will be a mini dashboard that updates with new scores).
I am a little lost how how to go through the column find each entry for the name listed in the J column. I could do a vlookup, but it would stop at the first one it finds. I think it would be using the index function, small and an if statement based on a google search, but it is a bit over my head.
I attached a workbook to explain a little better. Thank you in advance for any help.