This is helpful when you must find the item’splacein the list instead of the item itself.
Most of the functions found in Excel require some input or information so you can calculate correctly.
This argument can be a number, text, logical value, or acell reference.
Lookup_array
Lookup_array (required) is the range of cells being searched.
Match_type
Match_type (optional) tells Excel how to match the Lookup_value with values in the Lookup_array.
The default value for this argument is 1.
The choices are -1, 0, or 1.
Leave cell D2 blank, as that particular cell will host the function.
Selectcell D2to make it the active cell.
Select theFormulastab of theribbonmenu.
ChooseLookup & Referenceto open theFunctiondrop-down list.
SelectMATCHin the list to open theFunction Argumentsdialog box.
(In Excel for Mac, theFormula Builderopens.)
Place the cursor in theLookup_valuetext box.
Selectcell C2in the worksheet to enter the cell reference.
Place the cursor in theLookup_arraytext box.
Highlightcells E2 to E7in theworksheetto enter the range.
Place the cursor in theMatch_typetext box.
Enter the number0on this line to find an exact match to the data in cell D3.
SelectOKto complete the function.
(In Excel for Mac, selectDone.)
The number5appears in cell D3 since the termGizmosis the fifth item from the top in the inventory list.
When you select cell D3, the complete function appears in theformula barabove the worksheet.
