EXCE L L TRAIN N ING MA A NUAL 5. FUN NCTIO ONS  5.1 IND DEX MAT TCH FUN NCTION  Let’s  =IN s use them t NDEX(A2:B6 to find out h 6,MATCH(A how many w A10,A2:A6,0) widgets we h ,2)  have in stoc ck. In B10 en nter the form mula:  The  spec array take  MATCH fu cified value  y, and the m e an example unction retur in a specifi match type, i e of using th rns the rela ied order. I in which we e INDEX an tive position t takes 3 ar e can specify nd MATCH f n of an item rguments: th y if we want  functions at  m in an array he lookup v  an exact ma  the same tim y that match value, the lo atch or not. me.  hes a  okup   Let’s  =MA ATCH(looku up_value, lo okup_array, , [match_typ pe])  Let’s s look at ano other functio on called MA ATCH. It’s s syntax is:  So, a spec and  wha text  for u as an examp cify our table  the final arg at is at the in  string MOT us as well.  ple type int e which is A gument is co ntersection o TOR OIL wh to A10 =ind A1 through B olumn numb of row 4, col hich is correc dex(A1:B6,4,1 B6. Next arg ber, and that lumn 1. So,  ct. So the IN 1). The first gument is ro t’s column 1  hit enter, an NDEX functi t argument i ow number,  . The functi nd we see th ion basically is “array” s and that’s ro ion should re hat it return y looks up v so we  ow 4,  eturn  ns the  alues  Using g the INDEX fun nction  =IND DEX(array,  row_num, [ column_num m])  The  inter  INDEX fun rsection of a nction (enter  a particular r  into spread row and colu dsheet) retur umn, in a giv rns a value o ven range. I or reference  It’s syntax is  of the cell a s:  at the  Page 13 GLYPH<g3>