Vlookup Tutorial Code

# created by python bits.Check out my channel: https://www.youtube.com/@python-bits

import openpyxl

daily_data = openpyxl.load_workbook('daily_data.xlsx')
master_data = openpyxl.load_workbook('master_data.xlsx')

daily_sheet = daily_data['Sheet1']
master_sheet = master_data['data']

for i in daily_sheet.iter_rows():
    id = i[0].value
    row_number = i[0].row
    for j in master_sheet.iter_rows():
        if j[0].value == id:
            daily_sheet.cell(row=row_number, column=4).value = j[1].value
            daily_sheet.cell(row=row_number, column=5).value = j[2].value
            daily_sheet.cell(row=row_number, column=6).value = j[3].value

daily_data.save('update_daily_sheet.xlsx')