EXCE L L TRAIN N ING MA A NUAL The  and  we e  first argum  we want th enter as the s ment to INDE he MATCH f second argu EX is A2 thr function to d ument to IND rough B6, ou determine w DEX: MATC ur lookup ar which row th CH(A10,A2:A rray. Next w he product m A6,0)  we need the motor oil is i e row  in, so  The  MAT MAT MAT  lookup valu TCH. Then t TCH functio TCH functio ue we want  the lookup a on, and we  on. So, MAT is in cell A1 array is just A want an ex TCH will try 0, which is m A2 through  xact match,  y to find the  motor oil, so  A6, so that’s so type 0 fo row number o A10 is the  s the second or the final  r in which M first argume d argument t argument t Motor oil is.  ent to  to the  o the  Then func retu prod our  stock argu then It re the  stock prod work the  to bo n we have  ction which  rn a value a duct, so that table, which k.   So typ ument to th n hit enters a eturns the n correct am k.  Try t y ducts in ce ks correctly INDEX fun oth VLOOK to tell the column to l after we’ve fo t will be colu h has the nu pe 2, as t he INDEX  and there we number 33,  mount of wi yping in ell A10 to  . So, we can ction is very UP and HLO e INDEX  ook in to  ound our  umn 2 of  umber in  the final  function,  e have it! which is  idgets in  different  see if it  n see that  y similar  OOKUP.  Page 14 GLYPH<g3>