Spreadsheet: 718945d1613424422-using-nested-vlookups-or-index-match-example
Sheet: Sheet1

Routing ID | Facility | Additional description
192011 | 20159 | WEQP105 WEQP178 WETC002 WHIP045 WMFS007
192011 | 11216 | WHIP022
192011 | 10917 | WCLN011, WEQP060
192011 | 91040 | WPOR032
192011 | 10907 | WCLN066, WEQP057
192011 | 91050 | WPOR032
192011 | 91051 | WPOR010
192011 | 10911 | WIG0219
192011 | 10911 | WIRE BRUSH POROUS TO REMOVE EXCESSIVE
192011 | 11245 | WPOR032
192011 | 11219 | WHIP043
192011 | 11219 | WITH SISSAL WHEEL AND COMPOUND AS
192011 | 11219 | EXTRACTION SURFACE WITH PL0413 AND
192011 | 10924 | WEQP230, WCLN068
192011 | 10912 | WCLN017,WEQP071,WEQP072,WEQP073
192011 | 10917 | WCLN011,WEQP060
192011 | 10919 | WEQP061, WCLN007
192011 | 10910 | WEQP081,WEQP083,WPAS009
192011 | 12118 | WBAL005
192011 | 5 | WQLT025
192011 | 87000 | WBAL012, WBAL013
192011B | 20159 | WEQP105 WEQP178 WETC002 WHIP045 WMFS007
192011B | 11216 | WHIP022
192011B | 10912 | WCLN017,WEQP071,WEQP072,WEQP073
192011B | 10900 | [NAME], WCLN045
192011B | 12130 | WOPR006
192011B | 11245 | [NAME]
192011B | 10924 | WEQP230, WCLN068
192011B | 11219 | WI00118, WHIP043
192011B | 11219 | WITH SISSAL WHEEL AND COMPOUND AS
192011B | 11219 | EXTRACTION SURFACE WITH PL0413 AND
192011B | 10912 | WCLN017,WEQP071,WEQP072,WEQP073
192011B | 10917 | WCLN011,WEQP060
192011B | 10919 | [NAME]
192011B | 10910 | WEQP081,WEQP083,WPAS009
192011B | 12118 | WBAL005
192011B | 87000 | WBAL012, WBAL013
192011S | 20159 | WEQP105 WEQP178 WETC002 WHIP045 WMFS007
192011S | 20159 | INSTALL SET SCREW
192011S | 91040 | WPOR032
192011S | 10907 | WCLN066
192011S | 10907 | WEQP057
192011S | 91050 | WPOR032
192011S | 10911 | WIRE BRUSH POROUS TO REMOVE EXCESSIVE
192011S | 11245 | WPOR032
192011S | 11219 | WITH SISSAL WHEEL AND COMPOUND AS | I08825
192011S | 11219 | EXTRACTION SURFACE WITH PL0413 AND | I08825
192011S | 10912 | WCLN017,WEQP071,WEQP072,WEQP073
192011S | 10910 | WEQP081,WEQP083,WPAS009
192011S | 12117 | WBAL005
192012 | 20159 | WEQP105 WEQP178 WETC002 WHIP045 WMFS007
192012 | 11216 | WHIP022
192012 | 10917 | WCLN011, WEQP060
192012 | 91040 | WPOR032
192012 | 10907 | WCLN066, WEQP057
192012 | 91050 | WPOR032
192012 | 91051 | WPOR010
192012 | 10911 | WIG0219
192012 | 10911 | WIRE BRUSH POROUS TO REMOVE EXCESSIVE
192012 | 11245 | WPOR032
192012 | 11219 | WHIP043
192012 | 11219 | WITH SISSAL WHEEL AND COMPOUND AS
192012 | 11219 | EXTRACTION SURFACE WITH PL0413 AND
192012 | 10924 | WEQP230, WCLN068
192012 | 10912 | WCLN017,WEQP071,WEQP072,WEQP073
192012 | 10917 | WCLN011,WEQP060
192012 | 10919 | WEQP061, WCLN007
192012 | 10910 | WEQP081,WEQP083,WPAS009
192012 | 12118 | WBAL005
192012 | 5 | WQLT025
192012 | 87000 | WBAL012, WBAL013
192012B | 20159 | WEQP105 WEQP178 WETC002 WHIP045 WMFS007
192012B | 11216 | WHIP022
192012B | 10912 | WCLN017,WEQP071,WEQP072,WEQP073
192012B | 10900 | [NAME], WCLN045
192012B | 12130 | WOPR006
192012B | 11245 | [NAME]
192012B | 10924 | WEQP230, WCLN068
192012B | 11219 | WI00118, WHIP043
192012B | 11219 | WITH SISSAL WHEEL AND COMPOUND AS
192012B | 11219 | EXTRACTION SURFACE WITH PL0413 AND
192012B | 10912 | WCLN017,WEQP071,WEQP072,WEQP073
192012B | 10917 | WCLN011,WEQP060
192012B | 10919 | [NAME]
192012B | 10910 | WEQP081,WEQP083,WPAS009
192012B | 12118 | WBAL005
192012B | 87000 | WBAL012, WBAL013
 |  |  | I08825
 |  |  | I08825
 |  |  | I08825
 |  |  | I08825
 |  |  | I08825
 |  |  | I08825
 |  |  | I08825
 |  |  | I08825
 |  |  | I08825
 |  |  | I08825
 |  |  | I08825
 |  |  | I08825
 |  |  | I08825
 |  |  | I08825
 |  |  |  |  |  |  |  |  | 192021
 |  |  | I08825
 |  |  | I08825