Spreadsheet: 375385d1423164936-need-help-using-lookup-or-index-match-between-sheets-sample-inventory
Sheet: INV 2

 |  |  | Description | FED -TOYO FTLP and GDY-DUN ASSOC | FET | ALL CA WHS
175I4AFE | FEDERAL | 155/55R14 | FED 155/55R14 69V FORMOZA FD1 | 31.33 |  | 95
125G3AFA | FEDERAL | 155/65R13 | FED 155/65R13 73T SS-657 | 27.36 |  | 20
147270 | TOYO | 155/80R13 | TOYO P155/80R13 79S EXTENSA AS | 44.19 |  | 4
206L6AFA | FEDERAL | 165/40R16 | FED 165/40R16 73V 595 EVO | 39.14 |  | 74
176J5AFE | FEDERAL | 165/50R15 | FED 165/50R15 73V FORMOZA FD1 | 36.64 |  | 79
176I4AFE | FEDERAL | 165/55R14 | FED 165/55R14 72V FORMOZA FD1 | 33.39 |  | 17
177H4AFE | FEDERAL | 175/60R14 | FED 175/60R14 79H FORMOZA FD1 | 32.57 |  | 10
297H6AFA | FEDERAL | 175/60R16 | FED 175/60R16 82H FORMOZA FD2 | 37.57 |  | 18
177G4AFE | FEDERAL | 175/65R14 | FED 175/65R14 82H FORMOZA FD1 | 32.52 |  | 12
147380 | TOYO | 175/65R14 | TOYO P175/65R14 81T EXTENSA AS | 49.03 |  | 6
762174406 | GOODYEAR | 175/80R13 | ST175/80R13C  LR-C MTHN TRLR BSL TL TTC | 57 |  | 5
148I4AFA | FEDERAL | 185/55R14 | FED 185/55R14 80V SS-595 | 38.25 |  | 8
245630 | TOYO | 185/55R15 | TOYO 185/55 R15 PROXES T1R  82V | 45.77 |  | 21
148I5AFA | FEDERAL | 185/55R15 | FED 185/55R15 82V SS-595 | 40.29 |  | 14
265004140 | DUNLOP | 185/55R16 | DUN  185/55R16 SPSPT7000 83H A | 76 |  | 29
148H3AFA | FEDERAL | 185/60R13 | FED 185/60R13 80H SS-595 | 31.98 |  | 17
128H4AFA | FEDERAL | 185/60R14 | FED 185/60R14 82H SS-657 | 33.53 |  | 20
147400 | TOYO | 185/60R14 | TOYO P185/60R14 82H EXTENSA AS | 50.13 |  | 8
706460492 | GOODYEAR | 185/60R15 | GDY  P185/60TR15 EAGLE LS  VSB | 63.5 |  | 24
128G4AFE | FEDERAL | 185/65R14 | FED 185/65R14 86H SS-657 | 35.38 |  | 4
128G5AFE | FEDERAL | 185/65R15 | FED 185/65R15 88H SS-657 | 39.61 |  | 8
113010 | TOYO | 185/65R15 | TOYO P185/65R15 86T VERSADO ECO TL | 64.22 |  | 4
762045406 | GOODYEAR | 185/80R13 | ST185/80R13C LR-C MTHN TRLR BSL TL  TTC | 62 |  | 4
209L6AFA | FEDERAL | 195/40R16 | FED 195/40R16 80W 595 EVO | 43.62 |  | 76
209L7AFA | FEDERAL | 195/40R17 | FED 195/40R17 81W 595 EVO | 46.2 |  | 36
149K5AFA | FEDERAL | 195/45R15 | FED 195/45R15 78V SS-595 | 39.95 |  | 40
209J5AFA | FEDERAL | 195/50R15 | FED 195/50R15 82V 595 EVO | 43.4 |  | 20
195300 | TOYO | 195/50R15 | TOYO 195/50R15 XL 86V  EXTENSA HP | 52.18 |  | 7
959J5AFE | FEDERAL | 195/50R15 | FED 195/50R15 82W 595RS-R | 55.02 |  | 6
160560 | TOYO | 195/50R15 | TOYO 195/50R15 PROXES R888 82V | 108.41 |  | 4
170100 | TOYO | 195/50R15 | TOYO 195/50R15 PROXES R1R 82V | 93.89 |  | 4
139J6AFE | FEDERAL | 195/50R16 | FED 195/50R16 84V SS-535 | 43.45 |  | 20
195650 | TOYO | 195/50R16 | TOYO 195/50R16 EXTENSA HP 4P | 60.78 |  | 10
265024255 | DUNLOP | 195/55R15 | DUN 195/55R15  [NAME] BSWTL | 49.95 |  | 100+
149I5AFA | FEDERAL | 195/55R15 | FED 195/55R15 85W SS-595 | 48.43 |  | 12
195310 | TOYO | 195/55R15 | TOYO P195/55R15 84V  EXTENSA HP | 55.85 |  | 6
170270 | TOYO | 195/55R15 | TOYO 195/55R15 PROXES R1R 85V | 98.07 |  | 4
195670 | TOYO | 195/55R16 | TOYO  195/55R16 EXTENSA HP  87V | 62.61 |  | 42
A19I6AFE | FEDERAL | 195/55R16 | FED 195/55RF16 87V FRMZA AZ01 FRF | 79.58 |  | 24
246700 | TOYO | 195/55R16 | TOYO 195/55 R16 PROXES T1R  91V | 62.66 |  | 23
113030 | TOYO | 195/55R16 | TOYO P195/55R16 86V VERSADO ECO TL | 74.82 |  | 10
149H4AFA | FEDERAL | 195/60R14 | FED 195/60R14 86H SS-595 | 37.78 |  | 12
129H4AFE | FEDERAL | 195/60R14 | FED 195/60R14 86H SS-657 | 35.8 |  | 12
147410 | TOYO | 195/60R14 | TOYO  195/60R14 86H EXTENSA AS | 52.82 |  | 6
407740374 | GOODYEAR | 195/60R15 | GDY 195/60R15  88T  ASSURANCE AS | 64.29 |  | 100+
788490365 | GOODYEAR | 195/60R15 | GDY 195/60R15 88H SL ASSURANCE AUTHORITY TL | 54 |  | 100+
732401500 | GOODYEAR | 195/60R15 | GDY 195/60R15 RSA 88H | 54 |  | 16
147550 | TOYO | 195/60R15 | TOYO P195/60R15 87T EXTENSA AS | 48.62 |  | 14
112280 | TOYO | 195/60R15 | TOYO 195/60R15 VERSADO LX II 88H | 63.61 |  | 8
407477374 | GOODYEAR | 195/65R15 | GDY 195/65R15 91T  ASSURANCE AS | 62.86 |  | 100+
706648163 | GOODYEAR | 195/65R15 | GDY P195/65R15 EAGLE LS2 | 59.5 |  | 100+
265016200 | DUNLOP | 195/65R15 | DUN   195/65R15 SP SPT 300  91H | 41.5 |  | 100+
129G5BFE | FEDERAL | 195/65R15 | FED 195/65R15 91T SS-657 | 40.44 |  | 40
129G5AFE | FEDERAL | 195/65R15 | FED 195/65R15 91H SS-657 | 41.07 |  | 24
147510 | TOYO | 195/65R15 | TOYO P195/65R15 89T EXTENSA AS | 52.72 |  | 13
113020 | TOYO | 195/65R15 | TOYO P195/65R15 89H VERSADO ECO TL | 66.08 |  | 8
265038565 | DUNLOP | 195/65R15 | DUN  P195/65R15  [NAME] | 54 |  | 5
112160 | TOYO | 195/65R15 | TOYO 195/65R16 VERSADO LXII  91H | 62.16 |  | 4
402289477 | GOODYEAR | 195/65R15 | P195/65R15 89S SL  INTEGRITY B03RPTL | 59 |  | 4
407736374 | GOODYEAR | 195/70R14 | GDY 195/70R14  91T  ASSURANCE AS | 67.29 |  | 100+
402827047 | GOODYEAR | 195/70R14 | GDY  P195/70SR14 INTEGRITY SPECI | 52 |  | 100+
147350 | TOYO | 195/70R14 | TOYO P195/70R14 90T EXTENSA AS | 54.84 |  | 24
147310 | TOYO | 195/75R14 | TOYO P195/75R14 92S EXTENSA AS WW | 56.87 |  | 5
140L6AFA | FEDERAL | 205/40R16 | FED 205/40R16 83V RF. SS-595 | 43.12 |  | 8
200L7AFA | FEDERAL | 205/40R17 | FED 205/40R17 84Y 595 EVO | 49.77 |  | 60
140L7AFA | FEDERAL | 205/40R17 | FED 205/40R17 80V SS-595 | 44.86 |  | 20
200L8AFA | FEDERAL | 205/40R18 | FED 205/40R18 86Y 595 EVO | 58.8 |  | 40
265024247 | DUNLOP | 205/45R16 | DUN 205/45R16  [NAME] BSWTL | 62 |  | 18
140K6AFA | FEDERAL | 205/45R16 | FED 205/45R16 83V SS-595 | 42.43 |  | 16
195320 | TOYO | 205/45R16 | TOYO 205/45R16 EXTENSA HP 87V    XL | 68.94 |  | 14
140K7AFA | FEDERAL | 205/45R17 | FED 205/45R17 84V SS-595 | 45.67 |  | 36
265024231 | DUNLOP | 205/45R17 | DUN  205/45ZR17  [NAME] BSWT | 95 |  | 6
130J5AFE | FEDERAL | 205/50R15 | FED 205/50R15 86V SS-535 | 43.96 |  | 5
255000 | TOYO | 205/50R15 | TOYO 205/50R15 PROXES RR | 141.34 |  | 4
236840 | TOYO | 205/50R15 | TOYO 205/50R15 PROXES RAR1 | 134.61 |  | 4
168200 | TOYO | 205/50R15 | TOYO 205/50R15 PROXES R888 86W | 124.48 |  | 4
265024251 | DUNLOP | 205/50R16 | DUN 205/50R16  87V S1 DIREZZA DZ101 BSWTL | 56 |  | 100+
140J6AFA | FEDERAL | 205/50R16 | FED 205/50R16 87W SS-595 | 50.89 |  | 24
200J6AFA | FEDERAL | 205/50R16 | FED 205/50R16 87W 595 EVO | 51.43 |  | 16
950J6AFE | FEDERAL | 205/50R16 | FED 205/50R16 87W 595RS-R | 61.03 |  | 12
170J6AFE | FEDERAL | 205/50R16 | FED 205/50R16 87V FORMOZA FD1 | 48.01 |  | 12
195330 | TOYO | 205/50R16 | TOYO 205/50R16 EXTENSA HP 91V | 67.24 |  | 4
140J7AFE | FEDERAL | 205/50R17 | FED 205/50R17 93W SS-595 | 53.9 |  | 20
A10J7BFE | FEDERAL | 205/50R17 | FED 205/50RF17 91W FRMZA AZ01 FRF | 92.14 |  | 8
195370 | TOYO | 205/50R17 | TOYO  205/50R17 EXTENSA HP  93V | 67.57 |  | 4
168060 | TOYO | 205/55R14 | TOYO 205/55R14 PROXES R888 85V | 126.39 |  | 6
130I5AFE | FEDERAL | 205/55R15 | FED 205/55R15 88V SS-535 | 44.93 |  | 7
407781374 | GOODYEAR | 205/55R16 | GDY 205/55R16 91H  ASSURANCE AS | 70.77 |  | 100+
788524365 | GOODYEAR | 205/55R16 | GDY 205/55R16 91H SL ASSURANCE AUTHORITY TL | 54 |  | 100+
788053710 | GOODYEAR | 205/55R16 | GDY P205/55R16 89H SL VIVA AUTHORITY FM   TL | 69 |  | 70
195510 | TOYO | 205/55R16 | TOYO  205/55R16 EXTENSA HP  94V XL | 71.07 |  | 34
265034055 | DUNLOP | 205/55R16 | DUN P205/55ZR16 SP SPORT 8000 89 | 59 |  | 25
[NAME] | FEDERAL | 205/55R16 | FED 205/55RF16 91W FRMZA AZ01 FRF | 83.88 |  | 24
732051500 | GOODYEAR | 205/55R16 | GDY   205/55R16 EAGLE RS-A VSB  91H | 79.7 |  | 16
200I6AFE | FEDERAL | 205/55R16 | FED 205/55R16 94W 595 EVO | 52.41 |  | 14
170I6AFE | FEDERAL | 205/55R16 | FED 205/55R16 91V FORMOZA FD1 | 48.83 |  | 12
112510 | TOYO | 205/55R16 | TOYO 205/55R16 VERSADO LXII  91H | 82.85 |  | 8
147650 | TOYO | 205/55R16 | TOYO  205/55R16 91H EXTENSA AS | 71.56 |  | 6
195660 | TOYO | 205/55R16 | TOYO  205/55R16 EXTENSA HP  91V | 74.06 |  | 4