Lookup Functions

Add To Profile

MS Excel provides several built-in lookup functions that can be used to find data in a worksheet. The most commonly used lookup function is the VLOOKUP function, which searches for a value in the leftmost column of a table and returns the value in the same row from a column you specify. The VLOOKUP function can be used with an exact match or an approximate match. If you want to use an exact match, you need to specify the fourth argument as FALSE or 0. If you want to use an approximate match, you need to specify the fourth argument as TRUE or 1. The HLOOKUP function works similarly to the VLOOKUP function, but it searches for a value in the top row of a table instead of the leftmost column. The Lookup function searches for a value in the first column of a table and returns the value in the same row from a column you specify. However, unlike the VLOOKUP and HLOOKUP functions, Lookup can only be used with an exact match. MS Excel also provides several other lookup functions, including the Match and Index functions. You can learn more about these functions by consulting MS Excel's help documentation.