4 Category Prefix a. To make JLE's inventory data easier to search and work with you uso column A to create a new column titled Category Prefix b. Table 101 matches each inventory item with a specific prefix c. You write a nested function in column A that automatically enters the appropriate prefix from Table 101 For examplo, A2 should display 802 and A3 should display 601 Table 101: Category Prefixes Categorya Prefixe Analyzera 6000 Centrifuges 5019 Gas Chromatographs 302 Spectrochotometerse 3 Usonic Cleanersa 5040 Data e Help O From oom Web Page Layout Parts Desing Connections con The Y 21 = L S Stocks Sort Filler What Foreca S " Data Tools DataTypes For - C sory Diets 602 1 Category Prefix Product Number Description 2 Gas Chromatograph 49068740 Model 17A dual ID pas chromato 3 Contrifuges 49033132 550 cell harvester 4 Ultrasonic Cleaners 19081729 console BC 300-126 6 cleaner 5 Ultrasonic Cleaners 19076057 bomb approximately 250ml press 6 G# Chromatograph 1906R457 ALS sampler 7 Centris 49035215 SW55 ultra without buckets 8 Centrifuges 49032058 proof enclosure 9 Gas Chromatograph 49067015 System 1 coll culture 10 Gas Chromatograph 19068077 3400 dual FD cap & packed GC 11 Centrifuges 49022296 PT2000 with and without goner 12 Souctrophotometer 4900012 homogenizer with stainless steel 13 Gas Chromatographe 49068155 5000 Chennai Jesothor 14 Gas Chromatograph 49060083 SAB FID & TCDGC 15 Ultrasonic Cluaners 49082244 Model 0-2 ultrasonic cleaning ba 16 Soutrooonster 19000235 Model 112 u vis literarometo 11 Anale 490099 00 Model 1403 storm blanco.ge F G Quantity on hand January February March 176 324 673 4/6 476 367 647 303 704 181 562 224 248 33 331 60 521 721 145 172 488 879 80 783 500 750 200 40 931 09 373 4 Category Prefix a. To make JLE's inventory data easier to search and work with you uso column A to create a new column titled Category Prefix b. Table 101 matches each inventory item with a specific prefix c. You write a nested function in column A that automatically enters the appropriate prefix from Table 101 For examplo, A2 should display 802 and A3 should display 601 Table 101: Category Prefixes Categorya Prefixe Analyzera 6000 Centrifuges 5019 Gas Chromatographs 302 Spectrochotometerse 3 Usonic Cleanersa 5040 Data e Help O From oom Web Page Layout Parts Desing Connections con The Y 21 = L S Stocks Sort Filler What Foreca S " Data Tools DataTypes For - C sory Diets 602 1 Category Prefix Product Number Description 2 Gas Chromatograph 49068740 Model 17A dual ID pas chromato 3 Contrifuges 49033132 550 cell harvester 4 Ultrasonic Cleaners 19081729 console BC 300-126 6 cleaner 5 Ultrasonic Cleaners 19076057 bomb approximately 250ml press 6 G# Chromatograph 1906R457 ALS sampler 7 Centris 49035215 SW55 ultra without buckets 8 Centrifuges 49032058 proof enclosure 9 Gas Chromatograph 49067015 System 1 coll culture 10 Gas Chromatograph 19068077 3400 dual FD cap & packed GC 11 Centrifuges 49022296 PT2000 with and without goner 12 Souctrophotometer 4900012 homogenizer with stainless steel 13 Gas Chromatographe 49068155 5000 Chennai Jesothor 14 Gas Chromatograph 49060083 SAB FID & TCDGC 15 Ultrasonic Cluaners 49082244 Model 0-2 ultrasonic cleaning ba 16 Soutrooonster 19000235 Model 112 u vis literarometo 11 Anale 490099 00 Model 1403 storm blanco.ge F G Quantity on hand January February March 176 324 673 4/6 476 367 647 303 704 181 562 224 248 33 331 60 521 721 145 172 488 879 80 783 500 750 200 40 931 09 373
