Openpyxl - XLOOKUP Function on an Entire Column in Excel Workbooks with Python

This video demonstrates how to use Python to apply the XLOOKUP function on an entire column in Excel. The video referenced about the prefix "_xlfn." string can be found here: https://www.youtube.com/watch?v=Qu7bGO6DkcM