I just need to know which rate apply to which product

such as

For example:

Item:State rate (4.75%):County rate (2%):Meal rate (1%):

CandyYYN

' Elnal File Edit View lnserl Formal Tools Data Window Help 33 9 rev ' iiTotalSales-NDV-WS Layout Formii Ias . 3;, Cut ..' (E) $7491I- Man9:1al>M Q 6 AA A- = 60/\" Sawsp'rext 'Generai v' H. L%' L?' (HY HIV Ev Gil Copy v B I U V Margaecanlsr v v % J . Candilinnal Forum Call Insert Deleis Formal 9' Farm! $ \"a Formatting 8518MB Slyles 55 : r ' Paste .4 B C D E F 5 H I l K L M N 8 P El R 5 1 2 Total Sale. Var-b name: My numberslisled mm Ihe grammar \"its SOLD, MDT 3 mm. 3 8m. Ima'I mu, nnn 4 Producu'lrvlcl: uaI P a: 5m EIcIlm: Mair-17 'rmal sdes]: Y er Ill 5m- R-Ie 4.73)' Y am My Rm a Mall new If mm 5 a T ma 10ml nu: 5 5 Miami 1 79 Central 15.88 $25.85 II 8 88 8.88 8 88 8 88 $25 85 7 Aspirin 1 49 Central 15.88 $22.35 8 88 8.88 8 88 8 88 s22 35 8 Battrrmrn uz 4 39 Central 5 88 $25 34 8 88 8 88 8 88 8 88 S25 34 9 5885andvuch 2 49 Grill 719.88 $1 798.31 8 88 8.88 8 88 8 88 $1,798 31 18 5eeri5-Pkl-le Prernisa 5 29 Central 821 88 8 88 8 88 8 88 8 88 $4 43 89 11 5.2412 Pk lull Premise 9 99 Central 424 88 8 88 8 88 8 88 8 88 $4,235 75 12 BeerlCasel-le Prernisa 15 99 Central 385.88 8 88 8.88 8 88 8 88 $4,892 94 13 Bottled Water 1 29 Central 985 88 $1,158 74 8 88 8 88 8 88 8 88 $1,158 74 14 Bread 2 19 Central 281.88 $448.19 8 88 8.88 8 88 8 88 $448 19 15 cahhage (Pmduced) - each 2 88 Nursery 19.88 538.88 8 88 8.88 8 88 8 88 $38 88 15 Candy Bars 8 99 Central 521 88 $515 79 8 88 8 88 8 88 8 88 $515 79 17 Canned Soup 1 59 Central 35.88 $58.84 8 88 8.88 8 88 8 88 $58 84 18 Danlalnupas thaumaa) - sadi 2 19 Nursery 8 88 $8 88 8 88 8 88 8 88 8 88 $8 88 19 (tree-e 3 19 Central 43 88 $137 17 8 88 8 88 I] 88 8 88 $137 17 28 Ch : burger 2 29 Grill 1,859.88 $2, 48.81 8 88 8.88 8 88 8 88 $2,448 81 21 Chewing5urn 8 89 Central 257 88 $237 53 8 88 I] 88 8 88 8 88 $237 53 22 Chewingiubarm 3 49 Central 57.88 $233.83 I] 88 8.88 I] 88 I] 88 $233 83 23 EhrislmasTrea-S Pt 28 88 Nursery 15.88 5328.88 8 88 8.88 8 88 8 88 $328 88 24 Christmas'rreed Pt 25 88 Nursery 22 88 $558 88 8 88 I] 88 8 88 8 88 $558 88 25 Chnslrnaeirea-s Pt 38 88 Nursery 43.88 $1,298.88 I] 88 8.88 I] 88 I] 88 $1,298 88 25 EhrislmasTnea-E Pt 35 88 Nursery 45 88 $1,518 88 8 88 I] 88 I] 88 I] 88 $1,518 88 27 ChristmasireeJ Pt 48 88 Nursery 27 88 $1,888 88 I] 88 I] 88 I] 88 I] 88 $1,888 88 28 EigirElLa-per park 4 89 Central 597.88 $3,488.33 8 88 8.88 8 88 8 88 $3,488 33 29 Eigamllzrpemamm 49 99 Central 37 88 $1,849 53 I] 88 I] 88 I] 88 I] 88 $1,849 53 38 Cigars 3 99 Central 28.88 $79.88 I] 88 8.88 I] 88 I] 88 $79 88 31 CelieelHotl 8 99 Central 1,248.88 51,235.52 8 88 8.88 8 88 8 88 $1,235 52 32 Cnakia 1 89 Central 554 88 $514 75 8 88 8 88 8 88 8 88 $514 75 33 Cum [Fludueadl -per|:. 8 75 Nursery 52.25 $39.19 8 88 8.88 8 88 8 88 $39 19 34 mammals (Pmaumaa: - parl] 8 89 Nursery 81 25 $72 31 8 88 8 88 8 88 8 88 $72 31 35 Panel maua 1 99 Central 18 88 $19 98 8 88 8 88 8 88 8 88 $19 98 35 Fan Sentieestmer 18 pg: : -perpg 8 38 Printing 54.88 $15.28 8 88 8.88 8 88 8 88 $15 28 37 FnSErvitar perpage 8 25 Printing 35 88 $9 88 8 88 8 88 8 88 8 88 $9 88 38 Fleur 2 79 Central 5.88 $13.95 8 88 8.88 8 88 8 88 $13 95 39 French Fr 1 39 Grill 2,139.88 52,973.21 8 88 8.88 8 88 8 88 $2,973 21 48 Fruiuuire 2 59 Central 9 88 $24 21 8 88 8 88 8 88 8 88 S24 21 41 Gawile {Regulari - pergal. 3 59 Central 29,875.58 $118, 29 8 88 8.88 8 88 8 88 $118,244 29 42 Gamila aim-guns: - par gal 3 79 Central 14 38 38 $55,515 15 8 88 8 88 8 88 8 88 $55,515 15 43 Gamma then-um; . pergai 3 89 Central 5,135 88 $23,859 84 8 88 8 88 8 88 8 88 $23,859 84 .4 armweslh 53. I988 NIH-um Inn :38 nnn min nnn nnn menu 4 ) NOV Sales SheetZ Sheets + Ready - E M u + 100% ' Elnal File Edit View lnserl Formal Tools Data Window Help ID 9 [1' ' iiTotalSales-NDV-WS Layout Formtr Ias v EEZLW' 'CalinrlEBndyl v\"11 ' AA A- = 50/" BJV-Irap'rext 'General .' \"V L?' LW' '3' 5" iv 5 I U V Mergaecanlsrv v % J ' Candilinnal Forum Call Insert DeleIs Formal 9' Farm! $ 9.5 Formatting es'retale Styles F6 : r ' (E) '5' 7-111-- MonQ:17PM Q 6 Paste .5 B C D 5 F 5 H I I K I. M N 5 P 1:1 Fl 5 4.1 ans-3211375\": 5a; 15 59 Nursery 155 $15 59 555 555 555 555 $1559 45 GrassSeeds- 15\": Bag 22 29 Nursery 1.55 $22.29 5 55 5.55 5 55 5 55 $22 29 45 GrassSeeds-zmb Bag 29 99 Nursery 255 $59 95 5 55 555 555 555 $59 95 42 Green Bean: (Fmuoalr 51311] 5 25 Nursery 54.55 $42.55 5 55 5.55 5 55 5 55 $42 55 45 Grrlled ChoueSandwicn 1 29 Grill 345.55 $445.55 5 55 5.55 5 55 5 55 $445 55 49 Hamburger 1 99 Grill 922 55 $1,555 23 5 55 5 55 5 55 5 55 $1,544 23 55 Hamburger Rolls 1 49 Central 251.55 $299.49 5 55 5.55 5 55 5 55 $299 49 51 HangingPIanIs 5 99 Nursery 31.55 5225.59 5 55 5.55 5 55 5 55 $225 59 52 HangrnEPlanIslgr-wn rnhousel 2 59 Nursery 33 55 $255 .12 5 55 5 55 5 55 5 55 $255 52 53 Hay Bela 25 55 Nursery 55.55 $1,355.55 5 55 5.55 5 55 5 55 $1,355 55 54 Headarne Powders 1 99 Central 14 55 $22 55 5 55 5 55 I] 55 5 55 $22 55 55 Honey Buns 1 59 Central 555.55 $515.94 5 55 5.55 5 55 5 55 $515 94 55 Humor; - s'ngIe 5 99 Grill 1,559.55 $1,555.31 I] 55 5.55 I] 55 I] 55 $1,555 31 52 145th . 3 2 59 Grill 355 55 $952 54 I] 55 I] 55 I] 55 I] 55 $952 5.1 55 Hot DugRuHs 1 49 Central 212.55 $315.55 5 55 5.55 5 55 5 55 $315 55 59 Ice Dream - pit 1 99 Central 15.55 $31.54 I] 55 5.55 I] 55 I] 55 $31 54 55 Lamrnatrnr REparLCqurs unly 1 55 FrInLIrIE 13 55 $13 55 5 55 5 55 5 55 5 55 $13 55 51 Legal Dacumenls-per page 5 25 Frmtmg 325.55 $52.55 5 55 5.55 5 55 5 55 $52 55 51 Milk- U2 Gal 2 59 Central 33 55 $55 42 I] 55 I] 55 I] 55 I] 55 $55 42 53 MIIkrGaHun 3 59 Central 23.55 $54.52 5 55 5.55 5 55 5 55 $54 52 54 1111115511; Dupicatiom ' -perpg ' 5 52 Frmting 425.55 $29.95 I] 55 5.55 I] 55 I] 55 $29 95 55 Nabs I] 59 Central 521 55 $355 39 I] 55 I] 55 I] 55 5 55 5355 39 55 Napkrns 2 59 Central 22.55 $55.95 5 55 5.55 5 55 5 55 $55 95 52 Oman Rlnss 1 59 Grill 555.55 51. 45.54 I] 55 5.55 I] 55 I] 55 $1,445 54 55 Paper Flzl 2 29 Central 5.1 55 $122 25 5 55 5 55 5 55 5 55 $122 25 59 PaoerTawels 5 59 Central 34.55 $193 5 5 55 5.55 5 55 5 55 $153 45 25 Faad'Ias {Fmdumnl - parl] 5 29 Nursery 51 25 $54 95 I] 55 I] 55 I] 55 I] 55 $54 95 21 Phumuplr per page 5 55 FrInlIng 542.55 $32.15 5 55 5.55 5 55 5 55 $32 15 22 PrrnienLoCho-eSanI-l {Wrapper-ll 1 39 Central 55.55 $22.54 5 55 5.55 5 55 5 55 $22 54 23 Plamr Forks 1 59 Central 5.1 55 $2.1 35 5 55 I] 55 5 55 5 55 S24 35 24 lem Knrva 1 59 Central $41.55 5 55 5.55 5 55 5 55 $41 55 25 Plastrr Spoons 1 29 Central $55.55 5 55 5.55 5 55 5 55 $55 55 25 Pork'n' Bans 1 59 Central $453 .14 5 55 5 55 5 55 5 55 $353 5.1 22 Fn'lain (Up in 55 pages: perpq. 5 55 Frmtmg $1.55 5 55 5.55 5 55 5 55 $1 55 25 PoIaILnChrps 5 99 Central 5223 19 5 55 I] 55 5 55 5 55 $223 19 29 Pulled PlanIs 5 59 Nursery $351.23 5 55 5.55 5 55 5 55 $351 23 55 Pulled PlanIslgrown rnlrousel 5 29 Nursery $355.12 5 55 5.55 5 55 5 55 $355 12 51 Funult'l'IernuHLlphu 'l Ire) 555 Nursery $1,135 55 5 55 555 555 555 $1,135 55 52 FunuIt'm - Large (Over 15 51s: 2 55 Nursery $1,455.55 5 55 5.55 5 55 5 55 $1,455 55 53 Resumes (Up 1515 pagei: perpg. 5 25 Frmting $155.55 5 55 5.55 5 55 5 55 $155 55 5.1 5altrneCrerlrers 2 19 Central 555 94 5 55 5 55 5 55 5 55 $55 9.1 55 sausage Dog {Heated 'n shale 111w: 1 39 Central $23.52 5 55 5.55 5 55 5 55 $23 52 55 shrubslpurrhasedl 5 29 Nursery $155 12 5 55 5 55 5 55 5 55 $155 12 4 ) NOV Sales SheetZ Sheets Ready - 5 M u + 15511n ' Elna! File Edit View Insert Format Tools Data Window Help 33 E mv ' iiTotalSales-NDV-WS Layout Formu Ias (E) '5' 74%-- Mon9:1?PM Q 6 Cut 7 i i . . u... '0 _ 7 9/ v Era Wrap Tm Generai v v 3:" t v E Y E! v v E5 Cow , Li Li B Paste Margagamsr v v % J 7\"\" Canditional Fnrmat Call Insert Delels Farmai 6' Format $ \"a Formatting as 19mg Slyles k F6 , r v A B E D E F G H | l K L M N D F El R S 86 Shrubsfpumhaxh 6 79 Nursery 23 88 $156 17 8 88 8 88 8 88 8 88 $156 17 87 50h Drinks 1 29 Central 7,162.88 39,238.98 8 88 8.88 8 88 8 88 $9,238 98 88 Squash (Financed: parl: 8 59 Nursery 95.88 $26.55 8 88 8.88 8 88 8 88 $26 55 89 smwams (Plummet!) . man I] 99 Nursery I] 88 $8 88 8 88 8 88 I] 88 8 88 $8 88 98 Sub sandwich -8' 3 IS 6n\" 482.88 $1,682.18 8 88 8.88 8 88 8 88 $1,682 18 91 Sun Sanwidl -12' E 19 Grin 289 88 $1,788 91 8 88 8 88 8 88 8 88 $1,788 91 92 Sugar 3 29 Central 8.88 $26.32 8 88 8.88 8 88 8 88 $26 32 93 'ramme: {FmduoeduzarlL 8 79 Nursery 121.15 $96.18 8 88 8.88 8 88 8 88 $96 18 99 Travei Kiis' ' a 29 Cznml 12 88 $51 98 8 88 8 88 8 88 8 88 551 IS 95 VegeLabie Seeds- how 8 69 Nursery 8.88 $8.88 8 88 8.88 8 88 8 88 $8 88 96 Men \"Sausage 8 99 Central 291.88 $288.89 8 88 8.88 8 88 8 88 $288 89 97 Watermaiuns{9mdum 3 88 Nursery I] 88 $8 88 8 88 8 88 I] 88 I1 I18 S8 88 98 wet wum 1 29 Central 61.88 $78.69 8 88 8.88 8 88 8 88 $78 69 99 WineiFnrliadI-Dprsmis l 99 Central 167 88 $833 ii 8 88 8 88 8 88 8 88 $813 33 188 Wmem niurllaerf Prawns: a 89 Central 137.88 $669.93 8 88 8.88 8 88 8 88 $669 93 181 YoungTraahunchasedl 9 99 Nursery 18.88 $179.82 8 88 8.88 8 88 8 88 $179 82 182 $256,978.23 $8 88 $8.88 $8 88 $8 88 $256,978 23 183 ll]! 185 186 187 188 189 118 111 112 113 111 115 115 117 118 119 128 121 122 123 129 125 128 127 128 4 ) NOV Sales SheetZ Sheet3 + l Ready E M u + mun:n