Spreadsheet: 40290d1238595971-vlookup-problem-copy-of-book3
Sheet: prodclass

PROD.CLASS | DESC.....................
001 | 'B' - REFRIGERATION & A/C
002 | 'F' - RANGE
003 | 'G' - ELECTRICAL PRODUCTS
004 | 'H' - TOOLS & INSTR
005 | 'J' - WASHER
006 | 'K' - DISHWASHER & DRYER
007 | 'L' - HEATING
008 | 'N' - WATER HEATER
009 | 'P' - BELTS
010 | 'R' - INSTALLATION SUPPS
011 | 'S' - MOTORS & ACCESS
012 | 'W' - INDUSTRIAL
013 | 'X' - CONSUMER PRODUCTS
014 | 'Z' - OFFICE SUPPLIES
100 | BELTS
101 | DEFROST TIMERS
102 | COLD CONTROLS
103 | DEFROST HEATERS
104 | DOMESTIC REFRGRTR PRTS
105 | ICE MAKER PARTS
106 | CONDENSATE PANS
107 | WATER HEATER
108 | ELEC. RANGE PARTS
109 | GAS RANGE PARTS
110 | COMMERCIAL KITCHEN
111 | R.V. COOKING CONTROLS
112 | ELEC. DRYER PARTS
113 | GAS DRYER PARTS
114 | [NAME]
115 | LDY PARTS
116 | INST. SUPPLIES
117 | WATER FILTERS
118 | FITTINGS
119 | TUBING
120 | DISPOSERS
121 | ICE MAKER PARTS
122 | COOLER PARTS
124 | INDUSTRIAL
125 | COMPACTOR
126 | MICROWAVE
200 | SPEC.TEST INST
201 | TEST INSTRUMENTS
202 | POWER TOOLS
203 | WRENCHES
204 | HAND TOOLS
205 | SCREWDRIVERS
206 | NUT DRIVERS
207 | HEX KEYS
208 | SPECIALTY TOOLS
209 | HAND HELD LIGHTING
210 | SAFETY/SECURITY
211 | WELDING EQUIPMENT
212 | BRAZING SOLDERING
213 | VACUUMS
214 | WHEELS & CASTERS
215 | MISC HARDWARE
216 | TERMINALS
217 | BATTERIES
218 | LADDERS
219 | [NAME]
220 | LIGHTING
221 | HEAT TAPES
222 | STORAGE
223 | HEATERS
224 | SPRAY PAINT
225 | TAPES
226 | SEALANTS
227 | PLUMBING PRODUCTS
228 | FASTENERS
229 | SHOP SUPPLIES
230 | AIR DISTRIBUTION
231 | VENTING
300 | THERMOSTATS
301 | SNAP DISC T-STATS
302 | RELAYS
303 | FAN CENTERS
304 | ELEC HTG
305 | TRANSFORMERS
306 | OIL HEATING
307 | FAN / LIMIT CONTROLS
308 | GAS [NAME]
309 | T'COUPLE & GENERATORS
310 | GAS CONTROLS
311 | HYDRONIC CONTROLS
312 | AIR COND COMPRSRS
313 | REFRIG CONDS
314 | SOLENOID VALVES
315 | AIR COND EQUIPMENT
316 | OEM AIRCOND PARTS
317 | DRYERS
318 | THERMOSTATIC EXP VALVE
319 | REFRIG COMPONENTS
320 | AIR QUALITY PRODUCTS
321 | HEAT PUMP CONTROLS
322 | REFRIG CONTROLS
323 | ELEC TIMERS
324 | REFRIGERANT
325 | AC/R SUPPLIES
326 | ICE MACHINE PARTS
327 | REFRIGERATION TOOLS
328 | COMPRESSOR CONTROLS
329 | MODULATING PRODUCTS
330 | REFRIG COMPRESSORS
331 | UNITS COOLERS
332 | Com. Refrigeration Equip
333 | R/R EQUIPMENT
334 | WATER FOUNTAINS
335 | MANUFACTURED HOUSING
336 | BOILERS
337 | ZONE CONTROL SYSTEMS
338 | OEM GAS PACKAGE UNITS
339 | RADIANT FLOOR HEATING
340 | POTABLE WATER SYSTEMS
341 | HYDRONIC HEATING
342 | HIGH VELOCITY AIR SYSTEM
343 | ELECTRONIC CONTROLS
401 | GENERAL PURPOSE MTRS
402 | BELT DRIVE MOTORS
403 | DIRECT DRIVE MOTORS
404 | CONDENSER FAN MOTORS
405 | DBL SHAFT MOTORS
406 | DEFINITE PURPOSE MTRS
407 | APPLIANCE MOTORS
408 | C FRAME MOTORS
409 | CAPACITORS
410 | FAN BLADES
411 | MOTOR MOUNTING PARTS
412 | MOTOR CONTROLS
413 | ELECTRICAL SUPPLIES
414 | SWITCHES
415 | WIRE
416 | DEFINITE PURPOSE CONTA
417 | BLOWER WHEELS
418 | HVACR BOOSTERS
419 | BLOWERS
420 | VENTILATORS
421 | FANS
422 | PUMPS
423 | HYDRONIC PARTS
425 | PNEUMATIC PARTS
426 | GAUGES
499 | MOTOR PROMOTION
500 | TECHNICAL MANUALS
501 | SOFTWARE
502 | WARRANTIES
510 | Natl. [NAME].
600 | SHEET METAL
601 | CHEMICAL PRODUCTS
602 | DUCT BOARD PRODUCT
603 | DUCT ACCESSORIES
990 | END
999 | MISC GOODS
332A | Ice Machine Cubers
332B | Ice Machine Flakers
332C | Ice Mach. Bins/Dispenser
332D | Reach-Ins
332E | Reach-In Parts
332F | Reach-In Accessories