task1.py

from openpyxl import load_workbook
  

data_file = '111.xlsx'
wb = load_workbook(filename=data_file)
data = wb['исходные']

filial_number = '01'
i = 2

while filial_number:
    cell = 'F{0}'.format(i)
    value = ("=IFS(E{0}='списки'!A$2, 'списки'!B$2, E{0}='списки'!A$3, "
             "'списки'!B$3, E{0}='списки'!A$4, 'списки'!B$4)")
    data[cell] = value.format(i)

    i += 1
    filial_number = data['E{0}'.format(i)].value

wb.save(data_file)