im kind of stuck
I want to find when a person was registered in the table , even when they are multiple ones
Lets say I search for John , then in another cell in a dropdown list it shows me the dates he was been registered

All of the data is stored in sheet number 2 , in a table
The search is in sheet 1

I tried using filter , using dynamic tables , and lookv and lookh

here is the file I uploaded in one drive