Get Shift Done: Tips and Tricks
Large spreadsheets can quickly become unwieldy, especially when you try to find specific information buried within volumes of data. Since the Lookup Wizard was retired in Microsoft Excel 365, the easiest and most effective method of searching a spreadsheet is to use the powerful VLOOKUP
and HLOOKUP
functions. This article provides an overview of these functions and examples showing how to use them.
First is the VLOOKUP
(Vertical Lookup) function. The sample worksheet uses a discount matrix for items purchased in bulk. We are trying to determine how much of a discount to give for a particular purchase order, based on the weight of the items purchased. The formula is: