Stop Using VLOOKUP in Excel! Do This Instead (Data Models Explained)
Here is a powerful alternative to VLOOKUP and XLOOKUP in Excel by utilizing Excel’s Data Models. I’ll walk you through importing data from one sheet to another using a customer worksheet and an orders worksheet. Credit to : Chris Menard