As a long-term Excel enthusiast, I have always enjoyed using VLOOKUP, one of Excel's best-known lookup functions. However, Microsoft's introduction of XLOOKUP in 2019 changed everything. Once I ...

Excel's VLOOKUP function lets you find data in columns in reference to the first column. Learn how to create it manually or build it easily.

VLOOKUP and Search are two functions that Excel uses to search for text. VLOOKUP finds data in a column and returns the contents of an adjacent cell.

Excel's VLOOKUP function searches cell arrays for data that you provide. The function often takes cell references as input, letting you easily apply the function to each cell in a range.

Following on from our time saving Excel shortcuts, we continue offering updated advice for the time-sensitive spreadsheet enthusiast. Back in 2013 John Gagnon wrote a very popular post about VLOOKUP ...