Formula Lookup Function Excel. Vlookup a2 a10 c20 2 true vlookup fontana b2 e7 2 false vlookup a2 client details a f 3 false. The excel lookup function performs an approximate match lookup in a one column or one row range and returns the corresponding value from another one column or one row range.
While doing financial analysis if we wish to compare two rows or columns we can use the lookup function. The vector type searches only one row or column while an array searches multiple rows and columns. Vlookup is one of the most powerful and top used functions in excel.
Let s say you have a simple list of 1000 clients with three columns.
The excel hlookup function the hlookup function is the missing part of the vlookup function. The function performs a rough match lookup either in a one row or one column range and returns the corresponding value from another one row or one column range. That s when the lookup function can be useful. As a vector and an array.
