Hi. I have a column full of names. So for example


Dogs
Alsatian
Alsatian_Young
Alsatian_Old
Corgi
Poodle
Labrador
Labrador_Black
Labrador_White

I also have a folder with file names as follows

Alsatian, Corgi, Poodle, Labrador

I need to retrieve some information from these files and it will go in the adjacent column. My problem is that in my list I have some Dog names which have more specific descriptions so for example the Alsatian_Young, but the thing to note is that the information for Alsation_Young must come from the "Alsatian.xls" file in the same way that the Labrador_White information exists in the "Labrador.xls" file. Therefore it is not as straightforward as just looping through all the files in the folder because I have these additional names in the columns that sometimes have to reference the same file.

Any ideas what a working solution could be?

Thanks for your help.