Select part of a sentence in a spreadsheet cell to define a condition that modifies the text of a tag in an xml file

I have a table like this :

With Python, fetch in Excel file the value of a cell in a row where a cell in the same row contains the character string from an xml file

I have several xml files with names like :

In Excel file, fetch the value of a cell in a row where a cell in the same row contains the character string from an xml file

I have several xml files with names like :