Spreadsheet: 99384d1298024224-excel-2007-if-and-or-vlookup-formatting-or-a-mixture-of-both-example-spreadsheet
Sheet: Sheet2

Specification | Size | Cost
W40 | 1500 | 100
W40 | 1200
W40 | 1000
W40 | 900
W40 | 800
W40 | 750
W40 | 600
W40 | 450
W40 | 400
W40 | 350
W40 | 300
W40 | 230
W40 | 180
W40 | 125
FX90 | 1500
FX90 | 1200
FX90 | 1000
FX90 | 900
FX90 | 800
FX90 | 750
FX90 | 600
FX90 | 450
FX90 | 400
FX90 | 350
FX90 | 300
FX90 | 230
FX90 | 180
FX90 | 125
TYWS | 1500
TYWS | 1200
TYWS | 1000
TYWS | 900
TYWS | 800
TYWS | 750
TYWS | 600
TYWS | 450
TYWS | 400
TYWS | 350
TYWS | 300
TYWS | 230
TYWS | 180
TYWS | 125
DIMWS | 1500
DIMWS | 1200
DIMWS | 1000
DIMWS | 900
DIMWS | 800
DIMWS | 750
DIMWS | 600
DIMWS | 450
DIMWS | 400
DIMWS | 350
DIMWS | 300
DIMWS | 230
DIMWS | 180
DIMWS | 125
A2 | 1500
A2 | 1200
A2 | 1000
A2 | 900
A2 | 800
A2 | 750
A2 | 600
A2 | 450
A2 | 400
A2 | 350
A2 | 300
A2 | 230
A2 | 180
A2 | 125
AC66 | 1500
AC66 | 1200
AC66 | 1000
AC66 | 900
AC66 | 800
AC66 | 750
AC66 | 600
AC66 | 450
AC66 | 400
AC66 | 350
AC66 | 300
AC66 | 230
AC66 | 180
AC66 | 125
REV60 | 1500
REV60 | 1200
REV60 | 1000
REV60 | 900
REV60 | 800
REV60 | 750
REV60 | 600
REV60 | 450
REV60 | 400
REV60 | 350
REV60 | 300
REV60 | 230
REV60 | 180
REV60 | 125
C51 | 1500
C51 | 1200
C51 | 1000
C51 | 900
C51 | 800
C51 | 750
C51 | 600
C51 | 450
C51 | 400
C51 | 350
C51 | 300
C51 | 230
C51 | 180
C51 | 125
HERT | 1500
HERT | 1200
HERT | 1000
HERT | 900
HERT | 800
HERT | 750
HERT | 600
HERT | 450
HERT | 400
HERT | 350
HERT | 300
HERT | 230
HERT | 180
HERT | 125
HERT | 1500
FX70 | 1200
FX70 | 1000
FX70 | 900
FX70 | 800
FX70 | 750
FX70 | 600
FX70 | 450
FX70 | 400
FX70 | 350
FX70 | 300
FX70 | 230
FX70 | 180
FX70 | 125
APP | 1500
APP | 1200
APP | 1000
APP | 900
APP | 800
APP | 750
APP | 600
APP | 450
APP | 400
APP | 350
APP | 300
APP | 230
APP | 180
APP | 125
FX60 | 1500
FX60 | 1200
FX60 | 1000
FX60 | 900
FX60 | 800
FX60 | 750
FX60 | 600
FX60 | 450
FX60 | 400
FX60 | 350
FX60 | 300
FX60 | 230
FX60 | 180
FX60 | 125
W20 | 1500
W20 | 1200
W20 | 1000
W20 | 900
W20 | 800
W20 | 750
W20 | 600
W20 | 450
W20 | 400
W20 | 350
W20 | 300
W20 | 230
W20 | 180
W20 | 125
NIMWS | 1500
NIMWS | 1200
NIMWS | 1000
NIMWS | 900
NIMWS | 800
NIMWS | 750
NIMWS | 600
NIMWS | 450
NIMWS | 400
NIMWS | 350
NIMWS | 300
NIMWS | 230
NIMWS | 180
NIMWS | 125
FX50 | 1500
FX50 | 1200
FX50 | 1000
FX50 | 900
FX50 | 800
FX50 | 750
FX50 | 600
FX50 | 450
FX50 | 400
FX50 | 350
FX50 | 300
FX50 | 230
FX50 | 180
FX50 | 125
REV35 | 1500
REV35 | 1200
REV35 | 1000
REV35 | 900
REV35 | 800
REV35 | 750
REV35 | 600
REV35 | 450
REV35 | 400
REV35 | 350
REV35 | 300
REV35 | 230
REV35 | 180
REV35 | 125
PL20 | 1500
PL20 | 1200
PL20 | 1000
PL20 | 900
PL20 | 800
PL20 | 750
PL20 | 600
PL20 | 450
PL20 | 400
PL20 | 350
PL20 | 300
PL20 | 230
PL20 | 180
PL20 | 125
W69 | 1500
W69 | 1200
W69 | 1000
W69 | 900
W69 | 800
W69 | 750
W69 | 600
W69 | 450
W69 | 400
W69 | 350
W69 | 300
W69 | 230
W69 | 180
W69 | 125
TY | 1500
TY | 1200
TY | 1000
TY | 900
TY | 800
TY | 750
TY | 600
TY | 450
TY | 400
TY | 350
TY | 300
TY | 230
TY | 180
TY | 125
DIM | 1500
DIM | 1200
DIM | 1000
DIM | 900
DIM | 800
DIM | 750
DIM | 600
DIM | 450
DIM | 400
DIM | 350
DIM | 300
DIM | 230
DIM | 180
DIM | 125
T1905 | 1500
T1905 | 1200
T1905 | 1000
T1905 | 900
T1905 | 800
T1905 | 750
T1905 | 600
T1905 | 450
T1905 | 400
T1905 | 350
T1905 | 300
T1905 | 230
T1905 | 180
T1905 | 125
C52 | 1500
C52 | 1200
C52 | 1000
C52 | 900
C52 | 800
C52 | 750
C52 | 600
C52 | 450
C52 | 400
C52 | 350
C52 | 300
C52 | 230
C52 | 180
C52 | 125
U2K | 600
U2K | 550
U2K | 500
U2K | 450
U2K | 425
U2K | 400
U2K | 375
U2K | 350
U2K | 325
U2K | 300
U2K | 275
U2K | 250
U2K | 225
U2K | 200
U2K | 182
U2K | 178
U2K | 162
U2K | 152
U2K | 140
U2K | 127
U2K | 112
U2K | 107
U2K | 100
U2K | 90
U2K | 82
U2K | 78
U2K | 72
U2K | 65
U2K | 62
U2K | 57
U2K | 52
U2K | 45
DIM | 600
DIM | 550
DIM | 500
DIM | 450
DIM | 425
DIM | 400
DIM | 375
DIM | 350
DIM | 325
DIM | 300
DIM | 275
DIM | 250
DIM | 225
DIM | 200
DIM | 182
DIM | 178
DIM | 162
DIM | 152
DIM | 140
DIM | 127
DIM | 112
DIM | 107
DIM | 100
DIM | 90
DIM | 82
DIM | 78
DIM | 72
DIM | 65
DIM | 62
DIM | 57
DIM | 52
DIM | 45
HERT | 600
HERT | 550
HERT | 500
HERT | 450
HERT | 425
HERT | 400
HERT | 375
HERT | 350
HERT | 325
HERT | 300
HERT | 275
HERT | 250
HERT | 225
HERT | 200
HERT | 182
HERT | 178
HERT | 162
HERT | 152
HERT | 140
HERT | 127
HERT | 112
HERT | 107
HERT | 100
HERT | 90
HERT | 82
HERT | 78
HERT | 72
HERT | 65
HERT | 62
HERT | 57
HERT | 52
HERT | 45
B60 | 600
B60 | 550
B60 | 500
B60 | 450
B60 | 425
B60 | 400
B60 | 375
B60 | 350
B60 | 325
B60 | 300
B60 | 275
B60 | 250
B60 | 225
B60 | 200
B60 | 182
B60 | 178
B60 | 162
B60 | 152
B60 | 140
B60 | 127
B60 | 112
B60 | 107
B60 | 100
B60 | 90
B60 | 82
B60 | 78
B60 | 72
B60 | 65
B60 | 62
B60 | 57
B60 | 52
B60 | 45
GOLZ | 600
GOLZ | 550
GOLZ | 500
GOLZ | 450
GOLZ | 425
GOLZ | 400
GOLZ | 375
GOLZ | 350
GOLZ | 325
GOLZ | 300
GOLZ | 275
GOLZ | 250
GOLZ | 225
GOLZ | 200
GOLZ | 182
GOLZ | 178
GOLZ | 162
GOLZ | 152
GOLZ | 140
GOLZ | 127
GOLZ | 112
GOLZ | 107
GOLZ | 100
GOLZ | 90
GOLZ | 82
GOLZ | 78
GOLZ | 72
GOLZ | 65
GOLZ | 62
GOLZ | 57
GOLZ | 52
GOLZ | 45
DT5 | 600
DT5 | 550
DT5 | 500
DT5 | 450
DT5 | 425
DT5 | 400
DT5 | 375
DT5 | 350
DT5 | 325
DT5 | 300
DT5 | 275
DT5 | 250
DT5 | 225
DT5 | 200
DT5 | 182
DT5 | 178
DT5 | 162
DT5 | 152
DT5 | 140
DT5 | 127
DT5 | 112
DT5 | 107
DT5 | 100
DT5 | 90
DT5 | 82
DT5 | 78
DT5 | 72
DT5 | 65
DT5 | 62
DT5 | 57
DT5 | 52
DT5 | 45
EDGE | 600
EDGE | 550
EDGE | 500
EDGE | 450
EDGE | 425
EDGE | 400
EDGE | 375
EDGE | 350
EDGE | 325
EDGE | 300
EDGE | 275
EDGE | 250
EDGE | 225
EDGE | 200
EDGE | 182
EDGE | 178
EDGE | 162
EDGE | 152
EDGE | 140
EDGE | 127
EDGE | 112
EDGE | 107
EDGE | 100
EDGE | 90
EDGE | 82
EDGE | 78
EDGE | 72
EDGE | 65
EDGE | 62
EDGE | 57
EDGE | 52
EDGE | 45
ULTIMAX | 600
ULTIMAX | 550
ULTIMAX | 500
ULTIMAX | 450
ULTIMAX | 425
ULTIMAX | 400
ULTIMAX | 375
ULTIMAX | 350
ULTIMAX | 325
ULTIMAX | 300
ULTIMAX | 275
ULTIMAX | 250
ULTIMAX | 225
ULTIMAX | 200
ULTIMAX | 182
ULTIMAX | 178
ULTIMAX | 162
ULTIMAX | 152
ULTIMAX | 140
ULTIMAX | 127
ULTIMAX | 112
ULTIMAX | 107
ULTIMAX | 100
ULTIMAX | 90
ULTIMAX | 82
ULTIMAX | 78
ULTIMAX | 72
ULTIMAX | 65
ULTIMAX | 62
ULTIMAX | 57
ULTIMAX | 52
ULTIMAX | 45
GR | 600
GR | 550
GR | 500
GR | 450
GR | 425
GR | 400
GR | 375
GR | 350
GR | 325
GR | 300
GR | 275
GR | 250
GR | 225
GR | 200
GR | 182
GR | 178
GR | 162
GR | 152
GR | 140
GR | 127
GR | 112
GR | 107
GR | 100
GR | 90
GR | 82
GR | 78
GR | 72
GR | 65
GR | 62
GR | 57
GR | 52
GR | 45
X3 | 600
X3 | 550
X3 | 500
X3 | 450
X3 | 425
X3 | 400
X3 | 375
X3 | 350
X3 | 325
X3 | 300
X3 | 275
X3 | 250
X3 | 225
X3 | 200
X3 | 182
X3 | 178
X3 | 162
X3 | 152
X3 | 140
X3 | 127
X3 | 112
X3 | 107
X3 | 100
X3 | 90
X3 | 82
X3 | 78
X3 | 72
X3 | 65
X3 | 62
X3 | 57
X3 | 52
X3 | 45
DT7 | 600
DT7 | 550
DT7 | 500
DT7 | 450
DT7 | 425
DT7 | 400
DT7 | 375
DT7 | 350
DT7 | 325
DT7 | 300
DT7 | 275
DT7 | 250
DT7 | 225
DT7 | 200
DT7 | 182
DT7 | 178
DT7 | 162
DT7 | 152
DT7 | 140
DT7 | 127
DT7 | 112
DT7 | 107
DT7 | 100
DT7 | 90
DT7 | 82
DT7 | 78
DT7 | 72
DT7 | 65
DT7 | 62
DT7 | 57
DT7 | 52
DT7 | 45
APP | 600
APP | 550
APP | 500
APP | 450
APP | 425
APP | 400
APP | 375
APP | 350
APP | 325
APP | 300
APP | 275
APP | 250
APP | 225
APP | 200
APP | 182
APP | 178
APP | 162
APP | 152
APP | 140
APP | 127
APP | 112
APP | 107
APP | 100
APP | 90
APP | 82
APP | 78
APP | 72
APP | 65
APP | 62
APP | 57
APP | 52
APP | 45
TURBO | 600
TURBO | 550
TURBO | 500
TURBO | 450
TURBO | 425
TURBO | 400
TURBO | 375
TURBO | 350
TURBO | 325
TURBO | 300
TURBO | 275
TURBO | 250
TURBO | 225
TURBO | 200
TURBO | 182
TURBO | 178
TURBO | 162
TURBO | 152
TURBO | 140
TURBO | 127
TURBO | 112
TURBO | 107
TURBO | 100
TURBO | 90
TURBO | 82
TURBO | 78
TURBO | 72
TURBO | 65
TURBO | 62
TURBO | 57
TURBO | 52
TURBO | 45
CREW | 600
CREW | 550
CREW | 500
CREW | 450
CREW | 425
CREW | 400
CREW | 375
CREW | 350
CREW | 325
CREW | 300
CREW | 275
CREW | 250
CREW | 225
CREW | 200
CREW | 182
CREW | 178
CREW | 162
CREW | 152
CREW | 140
CREW | 127
CREW | 112
CREW | 107
CREW | 100
CREW | 90
CREW | 82
CREW | 78
CREW | 72
CREW | 65
CREW | 62
CREW | 57
CREW | 52
CREW | 45
BBTEC | 600
BBTEC | 550
BBTEC | 500
BBTEC | 450
BBTEC | 425
BBTEC | 400
BBTEC | 375
BBTEC | 350
BBTEC | 325
BBTEC | 300
BBTEC | 275
BBTEC | 250
BBTEC | 225
BBTEC | 200
BBTEC | 182
BBTEC | 178
BBTEC | 162
BBTEC | 152
BBTEC | 140
BBTEC | 127
BBTEC | 112
BBTEC | 107
BBTEC | 100
BBTEC | 90
BBTEC | 82
BBTEC | 78
BBTEC | 72
BBTEC | 65
BBTEC | 62
BBTEC | 57
BBTEC | 52
BBTEC | 45
HILTI | 600
HILTI | 550
HILTI | 500
HILTI | 450
HILTI | 425
HILTI | 400
HILTI | 375
HILTI | 350
HILTI | 325
HILTI | 300
HILTI | 275
HILTI | 250
HILTI | 225
HILTI | 200
HILTI | 182
HILTI | 178
HILTI | 162
HILTI | 152
HILTI | 140
HILTI | 127
HILTI | 112
HILTI | 107
HILTI | 100
HILTI | 90
HILTI | 82
HILTI | 78
HILTI | 72
HILTI | 65
HILTI | 62
HILTI | 57
HILTI | 52
HILTI | 45
DT5 | 600
DT5 | 550
DT5 | 500
DT5 | 450
DT5 | 425
DT5 | 400
DT5 | 375
DT5 | 350
DT5 | 325
DT5 | 300
DT5 | 275
DT5 | 250
DT5 | 225
DT5 | 200
DT5 | 182
DT5 | 178
DT5 | 162
DT5 | 152
DT5 | 140
DT5 | 127
DT5 | 112
DT5 | 107
DT5 | 100
DT5 | 90
DT5 | 82
DT5 | 78
DT5 | 72
DT5 | 65
DT5 | 62
DT5 | 57
DT5 | 52
DT5 | 45
BBTEC | 600
BBTEC | 550
BBTEC | 500
BBTEC | 450
BBTEC | 425
BBTEC | 400
BBTEC | 375
BBTEC | 350
BBTEC | 325
BBTEC | 300
BBTEC | 275
BBTEC | 250
BBTEC | 225
BBTEC | 200
BBTEC | 182
BBTEC | 178
BBTEC | 162
BBTEC | 152
BBTEC | 140
BBTEC | 127
BBTEC | 112
BBTEC | 107
BBTEC | 100
BBTEC | 90
BBTEC | 82
BBTEC | 78
BBTEC | 72
BBTEC | 65
BBTEC | 62
BBTEC | 57
BBTEC | 52
BBTEC | 45
REEMA | 600
REEMA | 550
REEMA | 500
REEMA | 450
REEMA | 425
REEMA | 400
REEMA | 375
REEMA | 350
REEMA | 325
REEMA | 300
REEMA | 275
REEMA | 250
REEMA | 225
REEMA | 200
REEMA | 182
REEMA | 178
REEMA | 162
REEMA | 152
REEMA | 140
REEMA | 127
REEMA | 112
REEMA | 107
REEMA | 100
REEMA | 90
REEMA | 82
REEMA | 78
REEMA | 72
REEMA | 65
REEMA | 62
REEMA | 57
REEMA | 52
REEMA | 45
LIEBIG | 600
LIEBIG | 550
LIEBIG | 500
LIEBIG | 450
LIEBIG | 425
LIEBIG | 400
LIEBIG | 375
LIEBIG | 350
LIEBIG | 325
LIEBIG | 300
LIEBIG | 275
LIEBIG | 250
LIEBIG | 225
LIEBIG | 200
LIEBIG | 182
LIEBIG | 178
LIEBIG | 162
LIEBIG | 152
LIEBIG | 140
LIEBIG | 127
LIEBIG | 112
LIEBIG | 107
LIEBIG | 100
LIEBIG | 90
LIEBIG | 82
LIEBIG | 78
LIEBIG | 72
LIEBIG | 65
LIEBIG | 62
LIEBIG | 57
LIEBIG | 52
LIEBIG | 45