Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Lookup and Reference > LOOKUP
 

LOOKUP(lookup_value, array)

 
 

LOOKUP(lookup_value, lookup_vector, result_vector)

 
 Returns a value in a given row or column.

 lookup_valueThe value you want to look for.
 arrayThe number of rows you want the upper-left cell to refer to.
 lookup_vectorThe range of cells that contains only one row or one column.
 result_vectorThe range of cells that contains only one row or column.

 REMARKS
 
  		• This function can return a value either from a one-row or one-column range or from an array.
     
  		• The array form of this function looks in the first row or column of an array for a value and returns a value from the same position in the last row or column of the array.
     
  		• The "array" can be positive or negative (i.e. rows up or down).
     
  		• The vector form of this function looks in a one-row or one-column range for a value and returns a value from the same position in a second one-row or one-column range.
     
  		• This function is not case sensitive when searching for text strings. Uppercase and lowercase text is equivalent.
     
  		• The "lookup_value" can be a number, text, logical value, or a name or reference that refers to a one of these.
     
  		• The values on "lookup_value" must be placed in ascending order -1, 0, 1, A-Z, FALSE, TRUE, otherwise the function may not return the correct value.
     
  		• If "lookup_value" is smaller than the smallest value in "lookup_vector", then #N/A is returned.
     
  		• If "lookup_value" does not exist in "array", then the largest value in "lookup_vector" that is less than or equal to "lookup_value" is returned.
     
  		• If "result_vector" is not the same size as "lookup_vector", then

     EXAMPLES
     
     ABC
    1=LOOKUP("C",{"a","b","c","d";1,2,3,4}) = 3Wheels6
    2=LOOKUP("bump",{"a",1;"b",2;"c",3}) = 2Bearing8
    3=LOOKUP("Bearing",B1:B4,C1:C4) = 8Bolts11
    4=LOOKUP("Nuts",B2:B5,C2:C5) = 9Nuts9
    5=LOOKUP("Nuts",B1:C4,C1:C4) = 9  
    6=LOOKUP(B1,B1:B4) = Nuts  
    7=LOOKUP("Wheel",B1:B4,C1:C4) = 9  
    8=LOOKUP("Wheels",B1:B3,C1:C2) = 11  
    9=LOOKUP("C",{"a","b","c","d";1,2,3,4}) = 3  
    10=LOOKUP("banana",{"a",1;"b",2;"c",3}) = 2  
    11=LOOKUP("Wheels",{1,2,3}) = #N/A  
    		 
     Functions - L | Index - L | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top