Category: VLOOKUP

Two Ways to Compare Columns in Excel

Did you ever squint at two columns of data and examine them row by row to compare the values? Excel can do all that hard work for you in three different ways. Download CompareColumnsinExcel.xlsx to follow along. Note: All values will appear highlighted on the This Equals That Worksheet, initially.…
Read More

Excel Lookup Formula to Create Combined Tables

Lookup functions (VLOOKUP and HLOOKUP) are among the most useful Excel functions to pull data from multiple column-/row-sorted lists into a unified table. Think of it this way, these functions ask a simple question and return the answer. Question: is the data from a specific cell reference in this column…
Read More

Using VLOOKUP in an Excel Formula

Have you ever needed to look up current prices for an invoice for goods shipped? What about looking up the price discount for a loyal customer? Excel can do these or any other data lookup using the VLOOKUP function. This function’s precise parameter requirements can seem intimidating at first, and…
Read More