Category: VLOOKUP

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.…

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…

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…