Vlookup and concatenate multiple colums of date

Say in L4 on form test i want to look for the value of A4 in Drill data range a2 to z1000 and retun a concatenated string of something like "sav 407 : 08-may to 11-may"

how would that be done?
excel data.xlsx

could even move the data from F1 to i15 down below the first block if its easier

As Ahstangi said, having the data in 1 range of 4 columns makes this an easy one:

Formula:

Please Login or Register  to view this content.

One column is better for sure. Another formula that could work is;

Please Login or Register  to view this content.