LOOK UP to search one row or one column
Part Number Part Name Part Price Status
A001 water pump $68.39 In stock
A002 alternator $380.73 In stock
A003 air filter $15.49 In stock
A004 wheel bearing $35.16 Out of Stock
Vector Form
Frequency Color
4.14 red
4.19 orange
5.17 yellow
5.77 green
6.39 blue
*use vlookup or hlookup instead
Vector Form
Syntax LOOKUP(lookup_value, lookup_vector, [result_vector])
HLOOKUP when your comparison values are located in a row across the top of a table of data, and you w
VLOOKUP when your comparison values are located in a column to the left of the data you want to find.
Syntax HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
Axles Bearings Bolts Store Number
4 4 9 1
5 7 10 2
6 8 11 3
7
Part name Store Number Parts available 4
bearings 3 8
Enter Here Enter Here
INDEX Returns the value of an element in a table or an array, selected by the row and column numbe
Syntax INDEX(array, row_num, [column_num])
Data Data Data
Apples Lemons Oranges
Bananas Pears Grapes
Pineapples Plums Strawberries
Intersection
Row 2 Column 2 Apples INDEX(A43:C45,2,2) Value at the intersection of the second row and second colu
ENTER HERE
Row 3 Result 1
Column 2 Plums 2
3
MATCH function searches for a specified item in a range of cells, and then returns the relative position
Syntax MATCH(lookup_value, lookup_array, [match_type])
Match Type
1 or omitted MATCH finds the largest value that is less than or equal to lookup_value.
0 MATCH finds the first value that is exactly equal to lookup_value.
-1 MATCH finds the smallest value that is greater than or equal to lookup_value.
Product Count
Bananas 25
Oranges 38
Apples 40
Pears 41
2 MATCH(39,B63:B66,1)
Because there is not an exact match, the position of the next lowest value (38) in the range B2:B5 is returned.
4 MATCH(41,B63:B66,0)
The position of the value 41 in the range B2:B5.
#N/A MATCH(40,B2:B5,-1)
Returns an error because the values in the range B2:B5 are not in descending order.
ENTER HERE
Part Number A001
Part Name water pump
Part Price $68.39
Status In stock
he top of a table of data, and you want to look down a specified number of rows.
e left of the data you want to find.
e_lookup])
cted by the row and column number indexes.
of the second row and second column
nd then returns the relative position of that item in the range.
lookup_value.
al to lookup_value.
38) in the range B2:B5 is returned.