Search a String and copy specific cell into another cell

Hello,

i will fill out the column I with names. Then i enter the names in the left table. Each name can only be written three times in the right table.
I want a loop that find for example the name Max and copy the first date in J2 the second date in L2 and the third date in N2 and the same for the time.

Thank you for your help

Mr. Sampaio,

Good afternoon!! While you can do this with a VBA code, this can also be done using the vlookup formula directly into the cell you want. For instance:

In cell J2 you would put in a formula like this:

=VLOOKUP(I2, A2:F6, 1, False)

This will look for the value in the cell I2 (name) from the range A2 to F6 (one day) and return the value of the first column (date) and will look up the exact name.
This formula would need tweaked a bit for certain cells, but after the formula has been put in, the sheet would automatically search each time information was entered when you calculate the sheet. I hope that made sense. Mr. 6StringJazzer is much better at this stuff than I am, just thought this might be an option for you.

Dome