Openpyxl - XLOOKUP an Entire Column across Multiple Tabs in Excel with Python | Data Automation
This video reviews how to apply the XLOOKUP function across multiple tabs in an excel workbook using the Python library Openpyxl. I use Anaconda's Jupyter Lab interface.
😄 Please consider supporting this channel and making this content possible:
☕ https://www.buymeacoffee.com/DataAuto...
🅿 / dataautomation
Video on how to use XLOOKUP with Python: • Openpyxl - XLOOKUP Function on an Ent...
Video on why "_xlfn." is required: • Openpyxl - XLOOKUP Function on an Ent...
Video on how to use the max_row attribute with Python: • Openpyxl - Finding the Last/Max Row a...
00:00 :: Intro and Workbook review
01:12 :: Loading in the workbook and one tab
01:30 :: VLOOKUP across Tabs with Python
03:37 :: Overview
#PythonExcelTutorial #openpyxl #data #DataAutomation #python #pythontutorial #excel #pythonautomation #pythonprogramming #xlookup #xlookupformula #referencing #jupyterlab