Look Up Data. When you need to search for a specific data in one row or one column will use lookup function its main purpose is to look up a value in a one column or row range or an array two dimensional array table of data. On the formulas tab in the solutions group click lookup.
This article gives you a quick vlookup refresher then links to more. Lookup function is an inbuilt function categorized under lookup and reference functions. On the formulas tab in the solutions group click lookup.
Lookup function is not case sensitive.
Create a lookup formula with the lookup wizard excel 2007 only click a cell in the range. How to load the lookup. Use vlookup hlookup and other functions like index and match to search for and find data based on values you enter. The formula for the function is as follows.
