A little from column A, a little from column B: XLOOKUP is the new, easier way to retrieve information across Excel spreadsheets.

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.

In this case, we used the VLOOKUP () function to add an important detail to a tracking list. Specially, we added a stipend amount for each location worked.

One function that anyone looking to master the spreadsheet program needs to know is VLOOKUP. It's easily one of the handiest ways to sort through and understand large reams of data.