Spreadsheet: 822824d1679554594-populating-column-based-on-table-id-and-category-sheet-1
Sheet: 1

Item ID | Price | Discounted price | Item Category |  |  | Items  $20 and over get 20% off
15001 | 17 |  |  |  |  | Items under $20 get no discount
15002 | 16
15011 | 25
15012 | 12
15017 | 25
15019 | 13
15021 | 29
15025 | 26
15026 | 23
15027 | 18
15028 | 12
15030 | 27 |  |  |  |  | Item ID | Item Category
15031 | 18 |  |  |  |  | 15036 | Harness
15036 | 16 |  |  |  |  | 15301 | Hardware
15037 | 18 |  |  |  |  | 15482 | Electronic
15039 | 15 |  |  |  |  | 15690 | AV
15040 | 27 |  |  |  |  | 15809 | Composite
15042 | 23 |  |  |  |  | 15969 | Wire
15046 | 19 |  |  |  |  | 16163 | LRU
15049 | 28
15051 | 23
15052 | 19
15054 | 13
15055 | 13
15057 | 14
15058 | 26
15062 | 10
15064 | 21
15065 | 30
15066 | 14
15067 | 18
15068 | 20
15070 | 14
15074 | 18
15075 | 10
15076 | 16
15078 | 12
15082 | 19
15083 | 19
15084 | 21
15085 | 10
15086 | 13
15087 | 27
15088 | 24
15090 | 14
15091 | 18
15094 | 22
15095 | 28
15097 | 10
15098 | 18
15099 | 30
15101 | 16
15103 | 13
15107 | 27
15108 | 20
15113 | 17
15117 | 12
15118 | 23
15120 | 22
15121 | 25
15122 | 16
15123 | 12
15124 | 24
15125 | 12
15127 | 15
15128 | 24
15130 | 23
15132 | 24
15134 | 18
15135 | 27
15136 | 14
15137 | 27
15138 | 19
15139 | 21
15143 | 21
15145 | 17
15149 | 26
15151 | 15
15154 | 17
15157 | 13
15159 | 23
15160 | 30
15163 | 13
15169 | 11
15170 | 21
15175 | 18
15177 | 17
15180 | 12
15181 | 26
15185 | 24
15186 | 28
15187 | 22
15188 | 25
15189 | 16
15190 | 11
15191 | 25
15192 | 18
15193 | 17
15195 | 16
15196 | 10
15197 | 14
15198 | 25
15200 | 27
15201 | 14
15202 | 15
15205 | 23
15208 | 26
15211 | 18
15213 | 27
15216 | 20
15219 | 12
15224 | 25
15225 | 27
15226 | 22
15227 | 10
15228 | 22
15229 | 18
15234 | 27
15237 | 10
15240 | 10
15242 | 27
15243 | 15
15245 | 12
15246 | 15
15249 | 20
15250 | 22
15253 | 14
15254 | 17
15258 | 15
15259 | 28
15260 | 20
15261 | 25
15266 | 15
15271 | 18
15272 | 21
15273 | 23
15274 | 10
15275 | 12
15276 | 14
15277 | 17
15279 | 20
15280 | 17
15281 | 26
15282 | 26
15283 | 23
15285 | 19
15286 | 23
15288 | 18
15289 | 12
15290 | 19
15291 | 22
15294 | 26
15296 | 21
15299 | 12
15301 | 16
15304 | 27
15305 | 25
15310 | 27
15311 | 10
15314 | 28
15316 | 17
15318 | 25
15322 | 25
15326 | 22
15329 | 17
15330 | 13
15333 | 17
15334 | 13
15337 | 11
15338 | 30
15342 | 26
15343 | 12
15348 | 24
15349 | 20
15350 | 29
15351 | 28
15354 | 25
15355 | 25
15359 | 18
15363 | 19
15364 | 22
15364 | 30
15366 | 19
15368 | 6
15370 | 28
15371 | 24
15372 | 28
15373 | 8
15373 | 30
15374 | 4
15374 | 25
15375 | 11
15378 | 8
15378 | 25
15379 | 22
15382 | 30
15383 | 19
15383 | 25
15384 | 10
15386 | 29
15387 | 21
15387 | 29
15388 | 28
15389 | 26
15390 | 30
15391 | 28
15392 | 29
15392 | 29
15394 | 13
15394 | 26
15395 | 16
15397 | 3
15397 | 18
15399 | 15
15400 | 28
15401 | 27
15402 | 25
15403 | 3
15403 | 10
15405 | 19
15407 | 1
15407 | 24
15408 | 20
15409 | 29
15410 | 27
15411 | 19
15412 | 24
15414 | 10
15415 | 5
15415 | 27
15417 | 12
15418 | 28
15419 | 26
15420 | 21
15420 | 23
15424 | 30
15425 | 15
15425 | 28
15426 | 16
15426 | 22
15428 | 14
15428 | 26
15431 | 23
15432 | 17
15432 | 30
15437 | 5
15438 | 21
15438 | 35
15439 | 20
15440 | 13
15441 | 16
15442 | 11
15443 | 24
15443 | 26
15445 | 16
15447 | 10
15447 | 24
15449 | 25
15450 | 22
15451 | 14
15452 | 11
15454 | 20
15455 | 24
15456 | 14
15457 | 15
15458 | 17
15460 | 17
15461 | 15
15463 | 23
15465 | 24
15465 | 31
15468 | 25
15469 | 23
15470 | 19
15471 | 14
15473 | 23
15476 | 19
15477 | 21
15482 | 2
15482 | 22
15483 | 27
15484 | 24
15484 | 27
15485 | 16
15486 | 22
15487 | 18
15489 | 20
15492 | 15
15493 | 3
15494 | 10
15494 | 10
15495 | 31
15496 | 24
15497 | 11
15498 | 13
15499 | 18
15500 | 16
15500 | 27
15503 | 28
15505 | 16
15505 | 29
15507 | 17
15508 | 25
15509 | 5
15510 | 24
15511 | 23
15511 | 30
15512 | 10
15514 | 11
15515 | 3
15515 | 14
15516 | 19
15517 | 13
15518 | 24
15520 | 5
15523 | 2
15524 | 25
15525 | 21
15528 | 12
15529 | 11
15529 | 25
15530 | 18
15531 | 18
15531 | 26
15532 | 21
15533 | 15
15534 | 15
15536 | 21
15536 | 33
15537 | 14
15537 | 30
15538 | 33
15540 | 27
15541 | 3
15542 | 19
15544 | 19
15545 | 19
15545 | 23
15546 | 25
15548 | 13
15549 | 20
15549 | 23
15553 | 29
15554 | 3
15554 | 25
15557 | 14
15558 | 12
15558 | 33
15560 | 19
15561 | 15
15562 | 10
15563 | 30
15565 | 21
15565 | 24
15566 | 15
15568 | 23
15569 | 22
15570 | 29
15571 | 11
15571 | 28
15572 | 28
15573 | 12
15575 | 16
15578 | 11
15580 | 10
15580 | 10
15582 | 5
15582 | 21
15583 | 16
15586 | 23
15586 | 29
15587 | 19
15587 | 28
15588 | 10
15589 | 22
15590 | 25
15592 | 13
15592 | 22
15593 | 26
15595 | 26
15596 | 4
15598 | 3
15598 | 24
15599 | 6
15600 | 27
15601 | 26
15602 | 18
15602 | 22
15604 | 3
15606 | 19
15607 | 28
15608 | 26
15610 | 22
15613 | 14
15613 | 27
15614 | 13
15615 | 25
15617 | 10
15617 | 12
15619 | 13
15621 | 24
15622 | 25
15622 | 29
15624 | 15
15625 | 17
15626 | 11
15627 | 4
15627 | 19
15629 | 2
15630 | 8
15631 | 20
15632 | 20
15632 | 24
15634 | 12
15636 | 23
15638 | 14
15639 | 11
15642 | 25
15644 | 16
15645 | 30
15646 | 4
15646 | 26
15647 | 14
15649 | 12
15650 | 17
15651 | 33
15652 | 16
15654 | 29
15655 | 6
15656 | 26
15657 | 14
15658 | 13
15658 | 20
15659 | 17
15661 | 26
15662 | 20
15664 | 29
15665 | 18
15666 | 4
15666 | 30
15668 | 24
15669 | 20
15669 | 24
15670 | 12
15672 | 14
15673 | 13
15674 | 12
15674 | 31
15675 | 6
15677 | 10
15678 | 19
15679 | 29
15680 | 10
15680 | 12
15681 | 21
15681 | 26
15682 | 10
15683 | 28
15684 | 22
15685 | 22
15685 | 29
15686 | 20
15688 | 15
15689 | 20
15689 | 24
15690 | 24
15691 | 19
15692 | 22
15694 | 29
15696 | 11
15697 | 20
15698 | 25
15699 | 22
15700 | 18
15701 | 16
15701 | 24
15703 | 10
15703 | 26
15704 | 17
15706 | 13
15706 | 24
15707 | 28
15708 | 8
15711 | 5
15711 | 18
15712 | 1
15712 | 25
15715 | 15
15715 | 21
15716 | 13
15718 | 12
15720 | 6
15720 | 30
15721 | 20
15723 | 32
15725 | 18
15726 | 20
15727 | 32
15728 | 19
15729 | 20
15730 | 5
15730 | 30
15732 | 30
15733 | 13
15733 | 30
15734 | 11
15734 | 34
15735 | 10
15736 | 11
15737 | 13
15737 | 17
15738 | 26
15739 | 19
15739 | 19
15742 | 10
15744 | 20
15745 | 17
15745 | 35
15746 | 27
15749 | 29
15750 | 16
15753 | 14
15753 | 32
15755 | 14
15756 | 24
15758 | 26
15758 | 30
15761 | 15
15762 | 17
15763 | 27
15764 | 28
15765 | 10
15767 | 29
15769 | 12
15771 | 9
15775 | 34
15776 | 29
15777 | 30
15779 | 1
15779 | 12
15783 | 30
15783 | 32
15784 | 19
15785 | 21
15786 | 12
15787 | 10
15788 | 14
15788 | 25
15789 | 22
15790 | 27
15791 | 19
15791 | 29
15792 | 27
15793 | 16
15795 | 14
15796 | 8
15796 | 14
15797 | 10
15798 | 18
15798 | 25
15801 | 20
15803 | 28
15804 | 3
15804 | 27
15805 | 18
15806 | 25
15808 | 30
15809 | 19
15809 | 23
15812 | 22
15812 | 29
15814 | 8
15816 | 10
15817 | 24
15818 | 21
15822 | 22
15823 | 6
15823 | 16
15824 | 18
15826 | 10
15826 | 19
15827 | 29
15829 | 10
15829 | 25
15830 | 8
15831 | 18
15832 | 20
15833 | 15
15834 | 30
15835 | 25
15836 | 25
15837 | 6
15838 | 23
15839 | 25
15840 | 23
15842 | 18
15842 | 35
15844 | 2
15846 | 11
15848 | 32
15849 | 17
15853 | 10
15853 | 27
15854 | 19
15855 | 27
15856 | 24
15858 | 25
15859 | 17
15860 | 10
15860 | 25
15862 | 13
15862 | 13
15863 | 11
15863 | 26
15864 | 26
15864 | 29
15865 | 24
15868 | 27
15869 | 15
15870 | 15
15870 | 18
15871 | 17
15871 | 23
15872 | 15
15873 | 15
15874 | 17
15875 | 18
15876 | 19
15876 | 24
15881 | 22
15882 | 13
15883 | 17
15884 | 24
15885 | 24
15887 | 10
15888 | 29
15889 | 22
15890 | 25
15891 | 13
15891 | 25
15894 | 23
15894 | 24
15896 | 25
15898 | 23
15899 | 13
15900 | 11
15902 | 21
15903 | 24
15905 | 30
15906 | 9
15906 | 12
15907 | 15
15908 | 17
15908 | 24
15913 | 12
15914 | 22
15915 | 21
15916 | 9
15916 | 27
15917 | 23
15918 | 13
15920 | 21
15921 | 11
15921 | 14
15922 | 27
15923 | 11
15925 | 23
15926 | 16
15926 | 19
15927 | 15
15928 | 12
15929 | 13
15929 | 14
15932 | 13
15933 | 11
15933 | 29
15935 | 28
15937 | 6
15938 | 11
15938 | 24
15939 | 22
15940 | 28
15941 | 7
15942 | 12
15943 | 18
15944 | 13
15945 | 26
15946 | 14
15946 | 27
15947 | 13
15948 | 4
15949 | 17
15950 | 22
15951 | 15
15953 | 1
15953 | 22
15954 | 25
15955 | 14
15956 | 23
15956 | 23
15958 | 13
15959 | 17
15960 | 27
15961 | 18
15962 | 9
15963 | 22
15964 | 27
15966 | 18
15967 | 18
15967 | 27
15968 | 14
15969 | 13
15970 | 15
15971 | 18
15971 | 27
15973 | 19
15974 | 17
15974 | 35
15975 | 27
15976 | 12
15976 | 25
15977 | 16
15978 | 12
15979 | 11
15981 | 10
15981 | 35
15984 | 23
15985 | 10
15985 | 21
15986 | 19
15989 | 20
15990 | 13
15991 | 11
15991 | 26
15993 | 13
15994 | 25
15995 | 19
15995 | 27
15996 | 24
15997 | 31
15998 | 21
15999 | 17
16000 | 12
16002 | 23
16003 | 7
16006 | 9
16008 | 6
16012 | 11
16017 | 17
16022 | 31
16024 | 5
16029 | 33
16030 | 20
16031 | 2
16035 | 31
16037 | 27
16042 | 27
16046 | 16
16048 | 15
16053 | 25
16054 | 27
16056 | 21
16059 | 34
16062 | 13
16066 | 9
16067 | 25
16069 | 20
16071 | 8
16072 | 11
16077 | 18
16078 | 17
16083 | 2
16087 | 14
16091 | 33
16095 | 7
16100 | 28
16102 | 21
16107 | 5
16108 | 11
16113 | 1
16115 | 29
16120 | 11
16122 | 31
16126 | 28
16131 | 18
16133 | 31
16135 | 6
16137 | 12
16141 | 25
16145 | 23
16148 | 26
16151 | 18
16155 | 33
16156 | 28
16161 | 22
16163 | 22
16166 | 14
16169 | 27
16171 | 6
16174 | 15
16178 | 35
16183 | 29
16184 | 13
16185 | 25
16186 | 15
16191 | 31
16193 | 19
16198 | 1
16200 | 23
16203 | 20
16204 | 25
16208 | 20
16212 | 28
16215 | 1
16216 | 2
16218 | 2
16220 | 8
16223 | 17
16228 | 33
16233 | 34
16236 | 21
16241 | 8
16245 | 14
16250 | 26
16251 | 6
16255 | 26
16257 | 10
16261 | 24
16262 | 19
16264 | 18
16267 | 15
16271 | 31
16275 | 13
16276 | 30
16281 | 12
16283 | 3
16288 | 19
16291 | 5
16292 | 11
16296 | 11
16298 | 7
16301 | 12
16303 | 13
16304 | 35
16307 | 17
16310 | 10
16315 | 24
16318 | 14
16323 | 13
16326 | 9
16328 | 7
16331 | 12
16332 | 14
16333 | 10
16334 | 31
16338 | 26
16339 | 7
16344 | 30
16346 | 24
16348 | 17
16350 | 3
16353 | 12
16358 | 33
16360 | 2
16361 | 12
16363 | 26
16367 | 7
16372 | 4
16376 | 4
16378 | 25
16383 | 30
16387 | 25
16390 | 23
16395 | 3
16396 | 29
16400 | 10
16402 | 6
16405 | 11
16408 | 16
16410 | 11
16414 | 14
16416 | 35
16421 | 1
16423 | 16
16426 | 32
16431 | 24
16435 | 1
16439 | 29
16444 | 7
16449 | 6
16451 | 16
16452 | 6
16456 | 6
16461 | 4
16464 | 4
16465 | 31
16470 | 33
16473 | 28
16476 | 10
16481 | 12
16484 | 4
16488 | 8
16492 | 17
16493 | 21
16498 | 18
16503 | 4
16505 | 14
16510 | 14
16514 | 13
16516 | 15
16518 | 31
16522 | 30
16527 | 26
16529 | 19
16534 | 4
16539 | 32
16544 | 21
16548 | 11
16551 | 31
16553 | 2
16555 | 18
16556 | 23
16557 | 13
16560 | 3
16563 | 35
16568 | 1
16572 | 21
16574 | 9
16575 | 6
16580 | 29
16585 | 18
16588 | 18
16592 | 28
16594 | 27
16595 | 35
16598 | 1
16603 | 11
16606 | 6
16608 | 14
16610 | 33
16615 | 23
16618 | 5
16621 | 35
16623 | 15
16626 | 25
16630 | 3
16633 | 8
16635 | 4
16637 | 33
16638 | 24
16643 | 17
16645 | 29
16647 | 23
16648 | 27
16653 | 13
16654 | 28
16658 | 9
16662 | 14
16666 | 11
16671 | 30
16673 | 31
16675 | 28
16680 | 1
16681 | 19
16686 | 1
16688 | 19
16693 | 21
16697 | 28
16700 | 20
16701 | 6
16704 | 11
16709 | 13
16710 | 22
16715 | 20
16717 | 14
16719 | 26
16723 | 33
16726 | 7
16729 | 27
16732 | 31
16737 | 4
16740 | 9
16744 | 13
16747 | 21
16751 | 26
16752 | 1
16755 | 3
16757 | 4
16760 | 35
16762 | 9
16763 | 4
16765 | 33
16768 | 18
16769 | 10
16773 | 2
16776 | 5
16781 | 4
16782 | 26
16784 | 6