Lookup and Reference Fenctions jection Of fows nd columns that stores and organizes data in a str w data range into a table, you can take advantage of ational feateres such on inserting Rows and Columns: To insert new ow oF corm, right-cick on the row mambe Column etter where you want to inser the new fow oF column and select “se 2 Deleting Rows and Columns: To delete arow or column, right-click onthe row number or otumn eter and select "Delete" from the context men. Ths wil remove the seected row ev eomonn {nd shi the remaining rows or columns toil the gap. 3. Resting Rows and Columns: To adjust the height of row or the width ofa column, lek and dra the bottom border ofthe rw number o the right borer ofthe coum lee’ unl te desires size is reached.Aernatvey, you can double-click the border to automatically reseethe ‘4 Hiding and Unicing Rows and Columns: To hide a row or column, ightcckon the row number column eter and selec “Hide” from the cntert menu, To unhide ahidden row orcohoney select the two adjacent wiible rows or columns, rightclick, and choose "Unhide™ rons 5: Freeing Rows and Cohn: retng ows or eolumns lows youto keep & portion of your ‘arcades sible wile sroling trough he ret ofthe data To reese ows or colar oto the "View" ab inthe oor, ck onthe Freer Panes dropdown, and select reese oe ow. “Freze Fst Colum,” or Freeze Panes," depending on our pects Creating and Managing Tables 2 Gonvertng Data Ran ino Table: Yo ceote abl selec the range of cals that conan your {ist inti headers nthe tool navgate to the “Insert tb and cick on the siacae bon Th wien the "reste Tbe” log box, where Youca onthe elie ange ‘and check the "My table has headers” option if applicable,the ale selected, aan the iat empy el Seo the ole tn to ea abel ou at ‘oreadieet Th wil male cairo srahoo coop ro elated Oat: arg yor dt loge ote ad pou eae ata togevern {ors ohms, Fe. Ts wi mat eet eeu sod naire lane Ue of ered ett Meee cue hue when ring. fie or wring ‘wth formulas Use them spanngy and ob when necesay lor lommetinc pore 5 appropriate clumn width, ow heights, and white pace. Ths wl mae you speee net easier tread and navigate. Sorting Oat for Canty nd nit speci ores, often o reves pattems, reds, or Sorting the proces of aranging your data ina Nv Menty the highest or lowest values, pop venta ‘elationships. By sorting your data, you can quick Sneatoweteror range recordin sphabetea or hroncogal ote: Heres how trons oacrna Spreadsheet: 1. Sect he Data Cickon a cet within he ohm you wan to sor. Atrnabve, you tan at» ‘ang of els to sort multiple eslumns smutancousyothe header row of our seatedrang ‘Aly the Fier: Cik’OX' to apy he er to your dt wilbedsolved whe the other rou wile oreo Using Advanced Fiterng Techniques then » Serna get Fert eta, atom tex te slow outer based rei such os winapi oe tat ete wth, ‘oren wih" hsean prog records th specie keyword or phrases, Fre ectt Wcardican be sedin com te fer to epeent unknown, characters Posen oraents any sequence of charac, whl tequesson nen eh represents a nee nace sean lar can bop outer your data bused on mons ress teria ‘2nd uncover hidden pater in your tent oamservenas, ming ‘Ar tscoe, espresso nade vo lows, corns, nd cls Thee fncamental bulking ocks Serve he bso orang od manana. ‘ows: hows ron horsotaly aro the sreaneet and are abled numerically, tring With 2. and snceasingsegueray, They ate te bahbone of ata orarzaon, often used Terese indi Clues: Clurns un vere and te able alphabetical Starting with and continuing through {he alphabet, then coubing up ae 2 (eA, AB, AC) Columas are ypcly used to represent specie aca serbatesor idswen the Soreacibetteace SERCNASAL IMS where you cnet cece ee Freezing Rows and Columns itcan be helpful to freeze specifi rows or columns to keep them ‘When working wit large datasets, smable whe colin though you data. Tiss particularly useful for header rows or key colsena at 1voomup “MOONUP(eotp retrence, serene clang, ret ohm. Jade,lookup_rode Mooxup “MOOR? (looup_rteence, reteenc cel rangeresut_row_index, lookup_made ) dscets the VIOORUP and HLOOKUP fants mtg ae quite sma However, they have sna eg eld ay aenton ta, mos rlaedtothe Rae vertical nature of VlooKUP and HuooKup+h. colamn index Voondey eu, Cece Une TALON in your reterence ane eens n Feference. That means when there nt nent match hat Your VLOORUP/MORUE hd LOOKUP and HOOKUP Example The folowing wil ev and expan the example of HLOOKUP and LOOKUP implementation an their Inthe example, you can see how we write LOOKUP and HLOOKUP in excel and the result we get rom them. The wings fr both are quite similar although you have to take dierent perspectives when B