The VLOOKUP & HLOOKUP functions
The VLOOKUP (Figures 71 and 72) and HLOOKUP functions return information based on data stored in a lookup table. The function attempts to match a value in one of its arguments to values in the first column (VLOOKUP) or first row (HLOOKUP) of the lookup table. If it finds a match, it returns the associated value.
Figure 71. This example illustrates the VLOOKUP function. When you enter an item number in cell B1, the formula in B2 attempts to match it to a value in the first column of the lookup table below it (A5:D12) . If it finds a match, it returns the value in the fourth column of the same row as the match. The formula in cell B2 is shown in cell C2.
Figure 72. If the formula in B2 doesn't find a match, it returns ...
Get Microsoft Excel X for Mac OS X: Visual QuickStart Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
