One critical aspect to remember when using VLOOKUP is that it can only search for data in the first column of the table array. For this reason, it’s important to organize your data accordingly.

VLOOKUP 201: The John Smith Problem and Going Left After you use VLOOKUP enough, you’ll encounter its limitations. For example: It only returns the first match it finds, even if there are hundreds of ...

The VLOOKUP function is one of the most useful when pulling information from an Excel database. Here's how it works and how you can start using it in your work.

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.

Learn how to use the VLOOKUP formula to compare a maximum of two columns to have common values returned or to locate missing data.

TEXTBEFORE and TEXTAFTER are a few more of my favorite Excel functions to clean messy spreadsheets. Excel's newer text ...

VLOOKUP is a formula that allows you to “look up” certain data and retrieve it into another table, by row. This function can be especially useful when you have a well-structured table with information ...

In Excel, you can apply direct formatting to cells' values or backgrounds to make the spreadsheet easier to read. However, when an Excel formula returns a set of values—known as a spilled array ...

Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done.