Spreadsheet: 116477d1311861612-can-you-use-vlookup-to-search-a-entire-spreadsheet-for-a-code-and-then-return-the-qty-example28-07-11-2-
Sheet: Page2

FullName | Code | Description | ExtendedDescription | PriceRetail | PriceOriginal | Qty | FileName05 | FileName06
[NAME] | 469LGE | [NAME]<br><br>The Azzurri Butte | <[NAME]-span" style="font-weight: normal; font-size: 13px; "><b>Azzurri Butte Mountain Bike</h5></b><br><br>The Azzurri Butte features a double butted premium 6061 aluminum frame with double strength down tube for a lighter, more compliant and durable ride.<br><br>An 80mm | 1 | 41 | -1 | 000471_129555156794062500_05.jpg | 000471_129555156798593750_06.jpg
[NAME] | 469MED | [NAME]<br><br>The Azzurri Butte | <[NAME]-span" style="font-weight: normal; font-size: 13px; "><b>Azzurri Butte Mountain Bike</h5></b><br><br>The Azzurri Butte features a double butted premium 6061 aluminum frame with double strength down tube for a lighter, more compliant and durable ride.<br><br>An 80mm-travel fork with size-specific spring rates means the suspension is dialed and ready to roll.<br><br>Light and durable double-walled alloy rims are tough enough to handle the bumps and vibration and Azzurri 60tpi tires use a special knob height for great rolling resistance. The durable, double-walled mountain alloy rims roll equally fast on bike and trails, bitumen and gravel, easily handling varied terrain and offer flat protection with a special tread pattern for traction to aid control on pavement or gravel.<br><br>The Azzurri Butte's lightweight [NAME] gearing system gives lighter faster shifting and the extra durable saddle has increased padding for on and off-road durability and ample comfort, giving you a great recipe for hours of satisfaction!<br><br></span></h5><h5>Specifications:</h5>Frame 6061 Aluminum&nbsp;<br>Fork Suspension&nbsp;<br>Groupset Shimano&nbsp;<br>Brakes Promax V-brake&nbsp;<br>Handle Bar Alloy&nbsp;<br>Stem Alloy&nbsp;<br>Seat Post Alloy&nbsp;<br>Saddle Velo&nbsp;<br>Pedal Alloy&nbsp;<br>Wheelset Alloy&nbsp;<br>Tires Kenda 26&nbsp;<br>Shifters Shimano TX50&nbsp;<br>Front [NAME] TY-32&nbsp;<br>Rear Derailleur Shimano 21spd&nbsp;<br>Crank Shimano&nbsp;<br>Cassette Shimano&nbsp;<br><br><h5>Geometry Chart</h5><br><img src="/images/Magma-Lava-Erupt-frame.jpg" height="202" width="500"> | 1 | 41 | 6 | 000471_129555156794062500_05.jpg | 000471_129555156798593750_06.jpg
[NAME] | 469SML | [NAME]<br><br>The Azzurri Butte | <[NAME]-span" style="font-weight: normal; font-size: 13px; "><b>Azzurri Butte Mountain Bike</h5></b><br><br>The Azzurri Butte features a double butted premium 6061 aluminum frame with double strength down tube for a lighter, more compliant and durable ride.<br><br>An 80mm-travel fork with size-specific spring rates means the suspension is dialed and ready to roll.<br><br>Light and durable double-walled alloy rims are tough enough to handle the bumps and vibration and Azzurri 60tpi tires use a special knob height for great rolling resistance. The durable, double-walled mountain alloy rims roll equally fast on bike and trails, bitumen and gravel, easily handling varied terrain and offer flat protection with a special tread pattern for traction to aid control on pavement or gravel.<br><br>The Azzurri Butte's lightweight [NAME] gearing system gives lighter faster shifting and the extra durable saddle has increased padding for on and off-road durability and ample comfort, giving you a great recipe for hours of satisfaction!<br><br></span></h5><h5>Specifications:</h5>Frame 6061 Aluminum&nbsp;<br>Fork Suspension&nbsp;<br>Groupset Shimano&nbsp;<br>Brakes Promax V-brake&nbsp;<br>Handle Bar Alloy&nbsp;<br>Stem Alloy&nbsp;<br>Seat Post Alloy&nbsp;<br>Saddle Velo&nbsp;<br>Pedal Alloy&nbsp;<br>Wheelset Alloy&nbsp;<br>Tires Kenda 26&nbsp;<br>Shifters Shimano TX50&nbsp;<br>Front [NAME] TY-32&nbsp;<br>Rear Derailleur Shimano 21spd&nbsp;<br>Crank Shimano&nbsp;<br>Cassette Shimano&nbsp;<br><br><h5>Geometry Chart</h5><br><img src="/images/Magma-Lava-Erupt-frame.jpg" height="202" width="500"> | 1 | 41 | 10 | 000471_129555156794062500_05.jpg | 000471_129555156798593750_06.jpg
[NAME] | 448LGE | [NAME]<br><br>The Azzurri Butte | <[NAME]-span" style="font-weight: normal; font-size: 13px; "><b>Azzurri Butte Mountain Bike</h5></b><br><br>The Azzurri Butte features a double butted premium 6061 aluminum frame with double strength down tube for a lighter, more compliant and durable ride.<br><br>An 80mm-travel fork with size-specific spring rates means the suspension is dialed and ready to roll.<br><br>Light and durable double-walled alloy rims are tough enough to handle the bumps and vibration and Azzurri 60tpi tires use a special knob height for great rolling resistance. The durable, double-walled mountain alloy rims roll equally fast on bike and trails, bitumen and gravel, easily handling varied terrain and offer flat protection with a special tread pattern for traction to aid control on pavement or gravel.<br><br>The Azzurri Butte's lightweight [NAME] gearing system gives lighter faster shifting and the extra durable saddle has increased padding for on and off-road durability and ample comfort, giving you a great recipe for hours of satisfaction!<br><br></span></h5><h5>Specifications:</h5>Frame 6061 Aluminum&nbsp;<br>Fork Suspension&nbsp;<br>Groupset Shimano&nbsp;<br>Brakes Promax V-brake&nbsp;<br>Handle Bar Alloy&nbsp;<br>Stem Alloy&nbsp;<br>Seat Post Alloy&nbsp;<br>Saddle Velo&nbsp;<br>Pedal Alloy&nbsp;<br>Wheelset Alloy&nbsp;<br>Tires Kenda 26&nbsp;<br>Shifters Shimano TX50&nbsp;<br>Front [NAME] TY-32&nbsp;<br>Rear Derailleur Shimano 21spd&nbsp;<br>Crank Shimano&nbsp;<br>Cassette Shimano&nbsp;<br><br><h5>Geometry Chart</h5><br><img src="/images/Magma-Lava-Erupt-frame.jpg" height="202" width="500"> | 1 | 41 | 17 | 000450_129555059351875000_05.jpg | 000450_129555059355312500_06.jpg
[NAME] | 448MED | [NAME]<br><br>The Azzurri Butte | <[NAME]-span" style="font-weight: normal; font-size: 13px; "><b>Azzurri Butte Mountain Bike</h5></b><br><br>The Azzurri Butte features a double butted premium 6061 aluminum frame with double strength down tube for a lighter, more compliant and durable ride.<br><br>An 80mm-travel fork with size-specific spring rates means the suspension is dialed and ready to roll.<br><br>Light and durable double-walled alloy rims are tough enough to handle the bumps and vibration and Azzurri 60tpi tires use a special knob height for great rolling resistance. The durable, double-walled mountain alloy rims roll equally fast on bike and trails, bitumen and gravel, easily handling varied terrain and offer flat protection with a special tread pattern for traction to aid control on pavement or gravel.<br><br>The Azzurri Butte's lightweight [NAME] gearing system gives lighter faster shifting and the extra durable saddle has increased padding for on and off-road durability and ample comfort, giving you a great recipe for hours of satisfaction!<br><br></span></h5><h5>Specifications:</h5>Frame 6061 Aluminum&nbsp;<br>Fork Suspension&nbsp;<br>Groupset Shimano&nbsp;<br>Brakes Promax V-brake&nbsp;<br>Handle Bar Alloy&nbsp;<br>Stem Alloy&nbsp;<br>Seat Post Alloy&nbsp;<br>Saddle Velo&nbsp;<br>Pedal Alloy&nbsp;<br>Wheelset Alloy&nbsp;<br>Tires Kenda 26&nbsp;<br>Shifters Shimano TX50&nbsp;<br>Front [NAME] TY-32&nbsp;<br>Rear Derailleur Shimano 21spd&nbsp;<br>Crank Shimano&nbsp;<br>Cassette Shimano&nbsp;<br><br><h5>Geometry Chart</h5><br><img src="/images/Magma-Lava-Erupt-frame.jpg" height="202" width="500"> | 1 | 41 | 16 | 000450_129555059351875000_05.jpg | 000450_129555059355312500_06.jpg
[NAME] | 448SML | [NAME]<br><br>The Azzurri Butte | <[NAME]-span" style="font-weight: normal; font-size: 13px; "><b>Azzurri Butte Mountain Bike</h5></b><br><br>The Azzurri Butte features a double butted premium 6061 aluminum frame with double strength down tube for a lighter, more compliant and durable ride.<br><br>An 80mm-travel fork with size-specific spring rates means the suspension is dialed and ready to roll.<br><br>Light and durable double-walled alloy rims are tough enough to handle the bumps and vibration and Azzurri 60tpi tires use a special knob height for great rolling resistance. The durable, double-walled mountain alloy rims roll equally fast on bike and trails, bitumen and gravel, easily handling varied terrain and offer flat protection with a special tread pattern for traction to aid control on pavement or gravel.<br><br>The Azzurri Butte's lightweight [NAME] gearing system gives lighter faster shifting and the extra durable saddle has increased padding for on and off-road durability and ample comfort, giving you a great recipe for hours of satisfaction!<br><br></span></h5><h5>Specifications:</h5>Frame 6061 Aluminum&nbsp;<br>Fork Suspension&nbsp;<br>Groupset Shimano&nbsp;<br>Brakes Promax V-brake&nbsp;<br>Handle Bar Alloy&nbsp;<br>Stem Alloy&nbsp;<br>Seat Post Alloy&nbsp;<br>Saddle Velo&nbsp;<br>Pedal Alloy&nbsp;<br>Wheelset Alloy&nbsp;<br>Tires Kenda 26&nbsp;<br>Shifters Shimano TX50&nbsp;<br>Front [NAME] TY-32&nbsp;<br>Rear Derailleur Shimano 21spd&nbsp;<br>Crank Shimano&nbsp;<br>Cassette Shimano&nbsp;<br><br><h5>Geometry Chart</h5><br><img src="/images/Magma-Lava-Erupt-frame.jpg" height="202" width="500"> | 1 | 41 | 19 | 000450_129555059351875000_05.jpg | 000450_129555059355312500_06.jpg