Lookup Functions

Lookup functions search for values in a table.
Each lookup function uses a different method for searching and returning a value.


Worksheet Functions

LOOKUPReturns the value in a row or column that matches a value in a row or column.
HLOOKUPThis function searches for a value in a particular row and returns an item from the same column.
Returns the value in a row that matches a value in the top row of a table.
The lookup column has to be the first column.
It can only return columns to the right.
It can only find the first occurrence.
VLOOKUPThis function searches for a value in a particular column and returns an item from the same row.
Returns the value in a column that matches a value in the first column of a table.
The lookup column has to be the first column.
It can only return columns to the right.
It can only find the first occurrence.
MATCHReturns the position of a value in an array or list.
INDEXReturns the value from a cell range which is the intersection of a row and a column.


Lookup Wizard

The Lookup Wizard was an additional add-in (removed in Excel 2010) that can be used to cross reference a particular column and row from a table.
This wizard will create a formula that is a combination of the INDEX and MATCH functions.
For more information regarding this add-in, please refer to the Lookup Wizard page.


 

© 2017 Better Solutions Limited. All Rights Reserved. © 2017 Better Solutions Limited

PrevNext