Openpyxl - INDEX/MATCH Function on an Entire Column in Excel Workbooks with Python | Data Automation
This video demonstrates how to apply the INDEX/MACTH function pair to 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
00:00 :: Intro and workbook review
00:22 :: INDEX/MATCH function function/argument review
02:12 :: INDEX/MATCH one cell with Python
02:48 :: INDEX/MATCH entire column with Python
04:20 :: Overview
#PythonExcelTutorial #openpyxl #DataAutomation #data #python #pythontutorial #excel #pythonautomation #pythonprogramming #referencing #indexmatch #jupyterlab