Spreadsheet: 148286d1333328446-drop-down-boxes-with-if-statement-and-vlookup-pricebook2
Sheet: Comparison 

 |  |  |  |  |  |  |  |  |  |  |  | Select | Comparison Table
 |  |  |  |  |  |  |  |  |  |  |  | A
 |  |  |  |  |  |  |  |  |  |  |  | B
 |  |  |  |  |  |  |  |  |  |  |  | D | Instructions Click Here
Blank | A | B | C | Framework | D | E | F | G | H | I | J | E
0 | 0.15 | 0.12 | 0.12 | 0 | 0.12 | 0.1 | 0.15 | 0.15 | 0.15 | 0.12 | 0.15
0 | 0 | 0.06 | 0.03 | 0 | 0.04 | 0.03 | 0 | 0.06 | 0 | 0.06 | 0.05 | Required Retail Margin % | 16
 |  |  |  |  |  |  |  |  |  |  | INPUT CODE | Code | Description | List Price | A Discount | Subtotal | [NAME]. [NAME] | [NAME] | Cost | GM% | Rebate % | Net after rebate | GM% after rebate | Retail Sell Rate | List Price | B Discount | Subtotal | [NAME]. [NAME] | [NAME] | Cost | GM% | Rebate % | Net after rebate | GM% after rebate | Retail Sell Rate | List Price | D Discount | Subtotal | [NAME]. [NAME] | [NAME] | Cost | GM% | Rebate % | Net after rebate | GM% after rebate | Retail Sell Rate | List Price | D Discount | Subtotal | [NAME]. [NAME] | [NAME] | Cost | GM% | Rebate % | Net after rebate | GM% after rebate | Retail Sell Rate
 |  |  |  |  |  |  |  |  |  |  | 32360 | 32360 | Product 1234 | 318.24 | 0.15 | 270.504 | 107.5 | 210.74 | 127.296 | 0.395957103539907 | 0 | 210.74 | 0.395957103539907 | 250.8809523809524 | 318.24 | 0.12 | 280.0512 | 107.5 | 210.74 | 127.296 | 0.395957103539907 | 0.04 | 202.3104 | 0.3707886495207365 | 250.8809523809524 | 318.24 | 0.12 | 280.0512 | 107.5 | 210.74 | 127.296 | 0.395957103539907 | 0.06 | 198.0956 | 0.3574011739786245 | 250.8809523809524 | 318.24 | 0.1 | 286.416 | 107.5 | 210.74 | 127.296 | 0.395957103539907 | 0.03 | 204.4178 | 0.3772753644741309 | 250.8809523809524
 |  |  |  |  |  |  |  |  |  |  | 32379 | 32379 | Product 1235 | 318.24 | 0.15 | 270.504 | 107.5 | 210.74 | 127.296 | 0.395957103539907 | 0 | 210.74 | 0.395957103539907 | 250.8809523809524 | 318.24 | 0.12 | 280.0512 | 107.5 | 210.74 | 127.296 | 0.395957103539907 | 0.04 | 202.3104 | 0.3707886495207365 | 250.8809523809524 | 318.24 | 0.12 | 280.0512 | 107.5 | 210.74 | 127.296 | 0.395957103539907 | 0.06 | 198.0956 | 0.3574011739786245 | 250.8809523809524 | 318.24 | 0.1 | 286.416 | 107.5 | 210.74 | 127.296 | 0.395957103539907 | 0.03 | 204.4178 | 0.3772753644741309 | 250.8809523809524
 |  |  |  |  |  |  |  |  |  |  | 32395 | 32395 | Product 1236 | 318.24 | 0.15 | 270.504 | 107.5 | 210.74 | 127.296 | 0.395957103539907 | 0 | 210.74 | 0.395957103539907 | 250.8809523809524 | 318.24 | 0.12 | 280.0512 | 107.5 | 210.74 | 127.296 | 0.395957103539907 | 0.04 | 202.3104 | 0.3707886495207365 | 250.8809523809524 | 318.24 | 0.12 | 280.0512 | 107.5 | 210.74 | 127.296 | 0.395957103539907 | 0.06 | 198.0956 | 0.3574011739786245 | 250.8809523809524 | 318.24 | 0.1 | 286.416 | 107.5 | 210.74 | 127.296 | 0.395957103539907 | 0.03 | 204.4178 | 0.3772753644741309 | 250.8809523809524
 |  |  |  |  |  |  |  |  |  |  | 51322 | 51322 | Product 1237 | 318.24 | 0.15 | 270.504 | 82.42 | 235.82 | 127.296 | 0.4601984564498346 | 0 | 235.82 | 0.4601984564498346 | 280.7380952380952 | 318.24 | 0.12 | 280.0512 | 82.42 | 235.82 | 127.296 | 0.4601984564498346 | 0.04 | 226.3872 | 0.4377067254685777 | 280.7380952380952 | 318.24 | 0.12 | 280.0512 | 82.42 | 235.82 | 127.296 | 0.4601984564498346 | 0.06 | 221.6708 | 0.4257430387764197 | 280.7380952380952 | 318.24 | 0.1 | 286.416 | 82.42 | 235.82 | 127.296 | 0.4601984564498346 | 0.03 | 228.7454 | 0.4435035633503449 | 280.7380952380952