We may be compensated for your purchase of any of the products featured on this page – it helps us keep the lights on :)
Excel tutorial on how to use the VLOOKUP formula in your spreadsheets. VLOOKUP can help save time when you need to find something within a dataset.
How does VLOOKUP work in Excel?
VLOOKUP, or vertical lookup, helps to find, or “look up,” data within a range of columns in an Excel spreadsheet. Once you identify what you want to look up, the function will search the columns within the specified range for your result.
The VLOOKUP function can be used to look up text or look up numbers in Excel. In the VLOOKUP example in this tutorial, we lookup both.