Spreadsheet: 34497d1231794430-vlookup-formula-is-showing-error-vlookup-formula
Sheet: ELEMENT

 | CODE | ELEMENT | QTY | LIST PRICE | BUY per UNIT NET PRICE | PACKAGE PRICE | NOTE
 | Silver/Aviation Blue Element |  |  |  |  |  | Product sold with upholstery color as is
 | MA052N0-ALK0GGGL | [NAME] | 1 | 2595 | 1946.25 | Package # 1 NET PRICE + T&I and Taxes |  | #N/A
 | [NAME] | ABDUCTOR        Silver-Blu Avi | 1 | 2595 | 1946.25 |  |  | #N/A
[NAME] | MA203N0-ALK0GGGL | CHEST PRESS     Silver-Blu Avi | 0 | 2795 | 2096.25 |  |  | #N/A
[NAME] | MA252N0-ALK0GGGL | VERTICAL TR     Silver-Blu Avi | 0 | 2795 | 2096.25 |  |  | #N/A
[NAME] | MA302N0-ALK0GGGL | LEG EXTENSION   Silver-Blu Avi | 0 | 2695 | 2021.25 |  |  | #N/A
[NAME] | MA352N0-ALK0GGGL | LEG CURL        Silver-Blu Avi | 0 | 2695 | 2021.25 |  |  | #N/A
 | MA500N0-ALK0GGGL | LEG PRESS       Silver-Blu Avi | 1 | 4995 | 3746.25 |  |  | #N/A
[NAME] | MA652N0-ALK0GGGL | ABDOMINAL       Silver-Blu Avi | 0 | 2695 | 2021.25 |  |  | #N/A
 |  |  |  | 23860 | 17895 | 16702 |  | #N/A
 |  |  |  |  | -0.25 | -0.3 |  | #N/A
 | CODE | ELEMENT |  | LIST PRICE | BUY per UNIT NET PRICE | DISCOUNT | NOTE
 | Silver/Black Element (old style stack shields) |  |  |  | 3495 |  | Product sold with upholstery color as is | #N/A
 | MA150N0-ALV0GGJL | SHOULDER PRESS  Silver-Black | 3 | 2795 | 2305.875 | -0.175 |  | #N/A
 | MA200N0-ALV0GGJL | CHEST PRESS     Silver-Black | 2 | 2795 | 2305.875 | -0.175 |  | #N/A
Brett - Garrish SOLD 100881 soa | MA650N0-ALV0GGJL | ABDOMINAL      Silver-Black | 1 | 2695 | 2223.375 | -0.175 |  | #N/A
 | MA550N0-ALV0GGJL | ARM CURL   Silver-Black | 1 | 2695 | 2223.375 | -0.175 |  | #N/A
 | MA950N0-ALV0GGJL | LOW ROW   Silver-Black | 3 | 2695 | 2223.375 | -0.175 |  | #N/A
 | MA350N0-ALV0GGJL | LEG CURL         Silver-Black | 1 | 2695 | 2223.375 | -0.175 |  | #N/A
 | MA250N0-ALV0GGJL | VERT. [NAME] | 0 | 2795 | 2305.875 | -0.175 |  | #N/A
 | Silver/Bordeaux Element |  |  |  | 5795 |  | Product sold with upholstery color as is | #N/A
 | MA102N0-ALM0GGGL | ABDUCTOR        Silver-Bordeau | 2 | 2595 | 2205.75 | -0.15 |  | #N/A
 | MA052N0-ALM0GGGL | [NAME] | 2 | 2595 | 2205.75 | -0.15 |  | #N/A
[NAME] | MA152N0-ALM0GGGL | SHOULDER PRESS  Silver-Bordeau | 2 | 2795 | 2375.75 | -0.15 |  | #N/A
 | MA203N0-ALM0GGGL | CHEST PRESS     Silver-Bordeau | 2 | 2795 | 2375.75 | -0.15 |  | #N/A
 | MA302N0-ALM0GGGL | LEG EXTENSION   Silver-Bordeau | 4 | 2695 | 2290.75 | -0.15 |  | #N/A
 | MA352N0-ALM0GGGL | LEG CURL            Silver-Bordeaux | 1
 | MA500N0-ALM0GGGL | LEG PRESS           Silver-Bordeaux | 1
 | MA703N0-ALM0GGGL | PECTORAL           Silver-Bordeaux | 1
 | MA403N0-ALM0GG0L | LAT MACHINE     Silver-Bordeau | 1 | 2595 | 2205.75 | -0.15 |  | #N/A
 | MA452N0-ALM0GGGL | LOWER BACK      Silver-Bordeau | 1 | 2695 | 2290.75 | -0.15 |  | #N/A
 | MA252N0-ALM0GGGL | VERT. TRACTION    Silver-Bordeau | 0 | 2795 | 2375.75 | -0.15 |  | #N/A
 | MA602N0-ALM0GGGL | ARM EXT         Silver-Bordeaux | 1
 | MA953N0-ALM0GGGL | LOW ROW         Silver-Bordeau | 3 | 2695 | 2290.75 | -0.15 |  | #N/A
 | PA03-ALM0GG | CRUNCH BENCH     Silver-Bordeau | 2 | 1145 | 973.25 | -0.15 |  | #N/A
 | Silver/Black Element (new style stack shields) |  |  |  | 3595 |  | Product sold with upholstery color as is | #N/A
Wood Bros…kk 12.20 | MA403N0-ALV0GG0L | LAT MACHINE     Silver-Black | 0 | 2595 | 2205.75 | -0.15 |  | #N/A
[NAME] 12.16 | MA350N0-ALV0GGGL | LEG CURL  Silver-Black | 0 | 2695 | 2290.75 | -0.15 |  | #N/A
[NAME] 12.16 | MA302N0-ALV0GGGL | LEG EXT   Silver-Black | 0 | 2695 | 2290.75 | -0.15 |  | #N/A
[NAME]. - Sold 1=1 Wood Bros | MA500N0-ALV0GGGL | LEG PRESS       Silver-Black | 7 | 4995 | 4245.75 | -0.15 |  | #N/A
 | MA652N0-ALV0GGGL | ABOMINAL   Silver-Black | 1 | 2695 | 2290.75 | -0.15 |  | #N/A
 | MA452N0-ALV0GGGL | LOWER BACK    Silver-Black | 1
 | MA703N0-ALV0GGGL | PECTORAL   Silver-Black | 1 | 2795 | 2375.75 | -0.15 |  | #N/A
 | MA552N0-ALV0GGGL | ARM CURL  Silver-Black | 1 | 2695 | 2290.75 | -0.15 |  | #N/A
 | MA602N0-ALV0GGGL | ARM EXT     Silver-Black | 1 | 2695 | 2290.75 | -0.15 |  | #N/A
Wood Bros…kk 12.20 | MA203N0-ALV0GGGL | CHEST PRESS   Silver-Black | 0 | 2795 | 2375.75 | -0.15 |  | #N/A
[NAME] 12.16 | MA152N0-ALV0GGGL | SHOULDER PRESS   Silver-Black | 1 | 2795 | 2375.75 | -0.15 |  | #N/A
 | MA750N0-ALV0GGGL | [NAME] | 1 | 2695 | 2290.75 | -0.15 |  | #N/A
 | MA953N0-ALV0GGGL | LOW ROW         Silver-Black | 3 | 2695 | 2290.75 | -0.15 |  | #N/A
[NAME] | MA805N0-AL00GG0L | ERCOLINA        Silver | 0 | 1895 | 1610.75 | -0.15 |  | #N/A
 | MA855N0-AL00GG0L | CABLE [NAME] | 1 | 2995 | 2545.75 | -0.15 |  | #N/A
 | MA905N0-AL00GG0L | ERCOLINA REHAB  Silver | 0 | 2395 | 2035.75 | -0.15 |  | #N/A
 | Black/Black Element (new style stack shield) |  |  |  | 5795 |  | Product sold with upholstery color as is | #N/A
Frost for Van 12.18 | MA152N0-ANV0GGJL | SHOULDER PRESS  Black-Black | 1 | 2795 | 2445.625 | -0.125 |  | #N/A
Frost for Van 12.18 | MA203N0-ANV0GGJL | CHEST PRESS   Black-Black | 1 | 2795 | 2445.625 | -0.125 |  | #N/A
Frost for Van 12.18 | MA302N0-ANV0GGJL | LEG EXTENSION  Black-Black | 1 | 2695 | 2358.125 | -0.125 |  | #N/A
Frost for Van 12.18 | MA352N0-ANV0GGJL | LEG CURL    Black-Black | 1 | 2695 | 2358.125 | -0.125 |  | #N/A
Frost for Van 12.18 | MA403N0-ANV0GG0L | LAT MACHINE     Black-Black | 1 | 2595 | 2270.625 | -0.125 |  | #N/A
 | MA953N0-ANV0GGJL | LOW ROW    Black-Black | 1
 | MA500N0-ANV0GGJL | LEG PRESS    Black-Black | 1 | 4995 | 4370.625 | -0.125 |  | #N/A
 | MA552N0-ANV0GGJL | ARM CURL   Black-Black | 1 | 2695 | 2358.125 | -0.125 |  | #N/A
 | MA602N0-ANV0GGJL | ARM EXT     Black-Black | 1 | 2695 | 2358.125 | -0.125 |  | #N/A
 | MA650N0-ANV0GGJL | ABDOMINAL  Black-Black | 1 | 2695 | 2358.125 | -0.125 |  | #N/A
Frost for Van 12.18 | PA04-ANV0GG | ADJUST. BENCH   Black-Black | 0 | 845 | 739.375 | -0.125 |  | #N/A