Spreadsheet: 136914d1326886725-strange-vlookup-result-baffled-carcase
Sheet: Prices

Code |  |  |  |  |  | Price | [NAME] | MiniFit | [NAME]
BOH659 | 600 | x | 575 | x | 720 | 84.05 | 79.52 | 86.27 | 81.73
BOH959 | 900 | x | 575 | x | 720 | 109.87 | 105.33 | 112.65 | 108.1
BU1059D | 1000 | x | 575 | x | 720 | 132.95 | 128.42 | 136.35 | 131.2
BU1059F | 1000 | x | 575 | x | 720 | 119.1 | 114.55 | 122.27 | 117.73
BU1059SD | 1000 | x | 575 | x | 720 | 132.95 | 128.42 | 136.35 | 131.2
BU1259D | 1200 | x | 575 | x | 720 | 133.37 | 128.83 | 136.75 | 132.22
BU1259F | 1200 | x | 575 | x | 720 | 119.48 | 114.93 | 122.65 | 118.12
BU359D | 300 | x | 575 | x | 720 | 61 | 56.45 | 62.55 | 58.02
[NAME] | 300 | x | 575 | x | 720 | 61 | 56.45 | 62.55 | 58.02
BU4559D | 450 | x | 575 | x | 720 | 68.95 | 64.4 | 70.72 | 66.18
BU4559F | 450 | x | 575 | x | 720 | 68.95 | 64.4 | 70.72 | 66.18
BU459D | 400 | x | 575 | x | 720 | 66.82 | 62.27 | 68.55 | 64
[NAME] | 400 | x | 575 | x | 720 | 66.82 | 62.27 | 68.55 | 64
BU559D | 500 | x | 575 | x | 720 | 71.95 | 67.42 | 73.83 | 69.3
[NAME] | 500 | x | 575 | x | 720 | 71.95 | 67.42 | 73.83 | 69.3
BU659D | 600 | x | 575 | x | 720 | 76.22 | 71.68 | 78.23 | 73.68
BU659F | 600 | x | 575 | x | 720 | 76.22 | 71.68 | 78.23 | 73.68
BU659F | 600 | x | 575 | x | 720
BU659FD | 600 | x | 575 | x | 720 | 76.22 | 71.68 | 78.23 | 73.68
BU659SD | 600 | x | 575 | x | 720 | 76.22 | 71.68 | 78.23 | 73.68
BU859D | 800 | x | 575 | x | 720 | 90.9 | 103.02 | 110.25 | 105.72
BU859F | 800 | x | 575 | x | 720 | 96.2 | 91.67 | 98.68 | 94.13
BU859SD | 800 | x | 575 | x | 720 | 90.9 | 103.02 | 110.25 | 105.72
BU959D | 900 | x | 575 | x | 720 | 114.05 | 109.5 | 116.83 | 112.28
BU959F | 900 | x | 575 | x | 720 | 102.68 | 98.13 | 105.25 | 100.7
BU959SD | 900 | x | 575 | x | 720 | 114.05 | 109.5 | 116.83 | 112.28
CB1059D | 1000 | x | 575 | x | 720 | 132.95 | 128.42 | 136.35 | 131.2
[NAME] | 1000 | x | 575 | x | 720 | 132.95 | 128.42 | 136.35 | 131.2
CB1259D | 1200 | x | 575 | x | 720 | 133.37 | 128.83 | 136.75 | 132.22
CB1259F | 1200 | x | 575 | x | 720 | 133.37 | 128.83 | 136.75 | 132.22
CB859D | 800 | x | 575 | x | 720 | 90.9 | 103.02 | 110.25 | 105.72
[NAME] | 800 | x | 575 | x | 720 | 90.9 | 103.02 | 110.25 | 105.72
CB959D | 900 | x | 575 | x | 720 | 114.05 | 109.5 | 116.83 | 112.28
CB959F | 900 | x | 575 | x | 720 | 114.05 | 109.5 | 116.83 | 112.28
CGB45D | 450 | x | 575 | x | 820 | 53.4 | 51.13 | 54.83 | 52.57
CGB45DH | 450 | x | 575 | x | 870 | 53.37 | 51.1 | 54.8 | 52.52
CWPU672 | 600 | x | 350 | x | 720 | 89.83 | 86.82 | 92.17 | 89.13
CWPU690 | 600 | x | 350 | x | 900 | 103.27 | 100.23 | 105.9 | 102.87
CWPU7572 | 750 | x | 350 | x | 720 | 98.92 | 95.13 | 101.27 | 97.48
CWPU7590 | 750 | x | 350 | x | 900 | 109.23 | 105.45 | 111.92 | 108.13
CWPU872 | 800 | x | 350 | x | 720 | 98.32 | 94.53 | 100.65 | 96.87
CWPU890 | 800 | x | 350 | x | 900 | 108.05 | 104.27 | 110.68 | 106.9
CWU672 | 600 | x | 290 | x | 720 | 73.8 | 70.78 | 75.53 | 72.5
CWU690 | 600 | x | 290 | x | 900 | 86.22 | 83.2 | 88.22 | 85.18
CWU7572 | 750 | x | 290 | x | 720 | 88.38 | 86.55 | 90.33 | 84.6
CWU7590 | 750 | x | 290 | x | 900 | 98.68 | 97.18 | 100.97 | 94.9
CWU772 | 700 | x | 290 | x | 720 | 88.33 | 84.55 | 90.28 | 86.5
CWU790 | 700 | x | 290 | x | 900 | 98.6 | 94.82 | 100.88 | 97.1
DU1059D | 1000 | x | 575 | x | 720 | 132.95 | 128.42 | 136.35 | 131.2
DU559D | 500 | x | 575 | x | 720 | 71.95 | 67.42 | 73.83 | 69.3
DU659D | 600 | x | 575 | x | 720 | 76.22 | 71.68 | 78.23 | 73.68
DU859D | 800 | x | 575 | x | 720 | 90.9 | 103.02 | 110.25 | 105.72
DU959D | 900 | x | 575 | x | 720 | 114.05 | 109.5 | 116.83 | 112.28
IF65923A | 600 | x | 575 | x | 2180 | 217.57
IF65923B | 600 | x | 575 | x | 2180 | 217.57
IF65923C | 600 | x | 575 | x | 2180 | 217.57
IF65924A | 600 | x | 575 | x | 2300 | 217.57 | 213.03 | 223.87 | 219.33
IF659A | 600 | x | 575 | x | 2000 | 217.57
IF659B | 600 | x | 575 | x | 2000 | 217.57
IF659C | 600 | x | 575 | x | 2000 | 217.57
LSB99F | 935 | x | 575 | x | 720 | 112.38 | 105.18 | 114.8 | 107.62
LU359 | 300 | x | 575 | x | 2000 | 165.65 | 161.1 | 170.47 | 165.93
LU35923 | 300 | x | 575 | x | 2180 | 165.65 | 161.1 | 170.47 | 165.93
LU35924 | 300 | x | 575 | x | 2300 | 165.65 | 161.1 | 170.47 | 165.93
LU559 | 500 | x | 575 | x | 2000 | 204.88 | 200.33 | 210.73 | 206.18
LU55923 | 500 | x | 575 | x | 2180 | 204.88 | 200.33 | 210.73 | 206.18
LU55924 | 500 | x | 575 | x | 2300 | 204.88 | 200.33 | 210.73 | 206.18
[NAME] | 1000 |  |  |  | 355 |  | 29.85 |  | 30.7
[NAME] | 1000 |  |  |  | 175 |  | 25.58 |  | 26.28
[NAME] | 900 |  |  |  | 355 |  | 27.37 |  | 28.13
[NAME] | 900 |  |  |  | 175 |  | 23.4 |  | 24.03
[NAME] | 800 |  |  |  | 355 |  | 27.25 |  | 28.02
[NAME] | 800 |  |  |  | 175 |  | 23.28 |  | 23.9
[NAME] | 600 |  |  |  | 355 |  | 21.75 |  | 22.33
[NAME] | 600 |  |  |  | 175 |  | 18.87 |  | 19.33
[NAME] | 500 |  |  |  | 355 |  | 16.67 |  | 17.05
[NAME] | 500 |  |  |  | 175 |  | 14.62 |  | 14.93
[NAME] | 450 |  |  |  | 355 |  | 15.47 |  | 15.8
[NAME] | 450 |  |  |  | 175 |  | 13.7 |  | 13.97
[NAME] | 400 |  |  |  | 355 |  | 13.93 |  | 14.22
[NAME] | 400 |  |  |  | 175 |  | 12.42 |  | 12.65
OCH1036 | 1000 | x | 290 | x | 360 | 59.57 | 55.78 | 60.88 | 57.1
OCH1045 | 1000 | x | 290 | x | 450 | 63.38 | 59.6 | 64.73 | 60.95
OCH645 | 600 | x | 290 | x | 450 | 42.88 | 39.87 | 43.7 | 40.68
OCH836 | 800 | x | 290 | x | 360 | 48.98 | 45.2 | 49.97 | 46.18
OCH845 | 800 | x | 290 | x | 450 | 52.73 | 48.95 | 53.75 | 49.97
OCH945 | 900 | x | 290 | x | 450 | 56.58 | 52.8 | 57.68 | 53.9
OCPH1036 | 1000 | x | 350 | x | 360 | 65.48 | 61.7 | 67.03 | 61.7
OCPH1045 | 1000 | x | 350 | x | 450 | 70.17 | 66.38 | 71.77 | 66.38
OCPH1050 | 1000 | x | 630 | x | 500 | 129.35 | 125.57 | 133.17 | 125.57
OCPH645 | 600 | x | 350 | x | 450 | 47.45 | 44.42 | 48.43 | 44.42
OCPH650 | 600 | x | 630 | x | 500 | 83.35 | 80.33 | 85.67 | 80.33
OCPH836 | 800 | x | 350 | x | 360 | 53.43 | 49.65 | 54.57 | 49.65
OCPH845 | 800 | x | 350 | x | 450 | 58.03 | 54.25 | 59.25 | 54.25
OCPH945 | 900 | x | 350 | x | 450 | 64.47 | 0.68 | 65.87 | 60.68
OH65923A | 600 | x | 575 | x | 2180 | 217.57
OH65923B | 600 | x | 575 | x | 2180 | 217.57
OH65923C | 600 | x | 575 | x | 2180 | 217.57
OH65923D | 600 | x | 575 | x | 2180 | 217.57
OH65923E | 600 | x | 575 | x | 2180 | 217.57
OH65923F | 600 | x | 575 | x | 2180 | 217.57
OH65923G | 600 | x | 575 | x | 2180 | 217.57
OH65923H | 600 | x | 575 | x | 2180 | 217.57
OH659A | 600 | x | 575 | x | 2000 | 217.57 | 213.03 | 223.87 | 219.33
OH659B | 600 | x | 575 | x | 2000 | 217.57
[NAME] | 600 | x | 575 | x | 2000 | 217.57
OH659D | 600 | x | 575 | x | 2000 | 217.57
OH659E | 600 | x | 575 | x | 2000 | 217.57
[NAME] | 600 | x | 575 | x | 2000 | 217.57
OH659G | 600 | x | 575 | x | 2000 | 217.57
OH659H | 600 | x | 575 | x | 2000 | 217.57
Panel | 473 |  |  |  |  |  | 8.22 |  | 8.3
Panel | 1200
Panel | 967 |  |  |  |  |  | 9.27 |  | 9.37
Panel | 867 |  |  |  |  |  | 8.63 |  | 8.7
Panel | 767 |  |  |  |  |  | 8.35 |  | 8.42
Panel | 567 |  |  |  |  |  | 7.83 |  | 7.87
PD1059D2 | 1000 | x | 575 | x | 720 | 132.95 | 128.42 | 136.35 | 131.2
PD1059D3 | 1000 | x | 575 | x | 720 | 132.95 | 128.42 | 136.35 | 131.2
PD1259D2 | 1200 | x | 575 | x | 720 | 133.37 | 128.83 | 136.75 | 132.22
PD659D2 | 600 | x | 575 | x | 720 | 76.22 | 71.68 | 78.23 | 73.68
PD659D3 | 600 | x | 575 | x | 720 | 76.22 | 71.68 | 78.23 | 73.68
PD859D2 | 800 | x | 575 | x | 720 | 90.9 | 103.02 | 110.25 | 105.72
PD859D3 | 800 | x | 575 | x | 720 | 90.9 | 103.02 | 110.25 | 105.72
PD959D2 | 900 | x | 575 | x | 720
PD959D3 | 900 | x | 575 | x | 720 | 114.05 | 109.5 | 116.83 | 112.28
PPD959D2 | 900 | x | 575 | x | 720 | 114.05 | 109.5 | 116.83 | 112.28
WBMU680 | 600 | x | 420 | x | 800 | 73.97 | 70.95 | 75.73 | 72.7
[NAME] | 1000 |  |  |  | 355 |  | 54.63 |  | 55.93
[NAME] | 1000 |  |  |  | 175 |  | 33.87 |  | 34.4
[NAME] | 900 |  |  |  | 355 |  | 48.83 |  | 49.92
[NAME] | 900 |  |  |  | 175 |  | 31.33 |  | 31.78
[NAME] | 800 |  |  |  | 355 |  | 45.23 |  | 46.27
[NAME] | 800 |  |  |  | 175 |  | 29.1 |  | 29.52
[NAME] | 600 |  |  |  | 355 |  | 36.58 |  | 37.42
[NAME] | 600 |  |  |  | 175 |  | 22.63 |  | 22.93
[NAME] | 500 |  |  |  | 355 |  | 33.55 |  | 34.28
[NAME] | 500 |  |  |  | 175 |  | 21.67 |  | 21.95
[NAME] | 450 |  |  |  | 355 |  | 30.27 |  | 30.93
[NAME] | 450 |  |  |  | 175 |  | 19.4 |  | 19.65
[NAME] | 400 |  |  |  | 355 |  | 29.83 |  | 30.48
[NAME] | 400 |  |  |  | 175 |  | 19.13 |  | 19.4
WPU1072 | 1000 | x | 350 | x | 720 | 98.7 | 94.92 | 101.12 | 97.33
WPU1090 | 1000 | x | 350 | x | 900 | 125.23 | 121.45 | 128.32 | 124.53
WPU372 | 300 | x | 350 | x | 720 | 49.53 | 46.5 | 50.6 | 47.58
WPU390 | 300 | x | 350 | x | 900 | 52.95 | 49.92 | 54.07 | 51.03
WPU4572 | 450 | x | 350 | x | 720 | 59.65 | 56.62 | 60.97 | 57.93
WPU4590 | 450 | x | 350 | x | 900 | 71 | 67.97 | 72.65 | 69.63
WPU472 | 400 | x | 350 | x | 720 | 54.78 | 51.75 | 56 | 52.98
WPU490 | 400 | x | 350 | x | 900 | 66.8 | 63.77 | 68.37 | 65.33
WPU572 | 500 | x | 350 | x | 720 | 60.42 | 57.38 | 61.75 | 58.72
[NAME] | 500 | x | 350 | x | 900 | 72.33 | 69.3 | 74.03 | 71.02
WPU672 | 600 | x | 350 | x | 720 | 64.7 | 61.67 | 66.2 | 63.17
WPU672 | 600 | x | 350 | x | 720 | 64.7 | 61.67 | 66.2 | 63.17
WPU690 | 600 | x | 350 | x | 900 | 79.9 | 76.88 | 81.8 | 78.78
WPU690 | 600 | x | 350 | x | 900 | 79.9 | 76.88 | 81.8 | 78.78
WPU872 | 800 | x | 350 | x | 720 | 83.53 | 79.75 | 85.37 | 81.58
WPU890 | 800 | x | 350 | x | 900 | 98.1 | 94.32 | 100.45 | 96.67
WPU972 | 900 | x | 350 | x | 720 | 89.17 | 85.38 | 91.22 | 87.43
WPU990 | 900 | x | 350 | x | 900 | 111.83 | 108.05 | 114.42 | 110.63
WU1072 | 1000 | x | 290 | x | 720 | 87.48 | 83.7 | 89.47 | 85.68
WU1090 | 1000 | x | 290 | x | 900 | 107.62 | 103.83 | 110.03 | 106.25
WU372 | 300 | x | 290 | x | 720 | 44.65 | 41.63 | 45.55 | 42.53
WU390 | 300 | x | 290 | x | 900 | 45.8 | 42.78 | 46.65 | 43.63
WU4572 | 450 | x | 290 | x | 720 | 53.3 | 50.27 | 54.37 | 51.35
WU4590 | 450 | x | 290 | x | 900 | 61 | 57.97 | 62.28 | 59.25
WU472 | 400 | x | 290 | x | 720 | 49.07 | 46.03 | 50.08 | 47.05
WU490 | 400 | x | 290 | x | 900 | 57.22 | 54.2 | 58.42 | 55.4
WU572 | 500 | x | 290 | x | 720 | 54.15 | 51.12 | 55.25 | 52.22
WU590 | 500 | x | 290 | x | 900 | 61.95 | 58.92 | 63.27 | 60.23
WU672 | 600 | x | 290 | x | 720 | 57.93 | 54.9 | 59.17 | 56.15
[NAME] | 600 | x | 290 | x | 720 | 57.93 | 54.9 | 59.17 | 56.15
WU690 | 600 | x | 290 | x | 900 | 68.95 | 65.93 | 70.43 | 67.42
WU690D | 600 | x | 290 | x | 900 | 68.95 | 65.93 | 70.43 | 67.42
WU872 | 800 | x | 290 | x | 720 | 75.07 | 71.28 | 76.58 | 72.8
WU890 | 800 | x | 290 | x | 900 | 84.5 | 80.72 | 86.35 | 82.57
WU972 | 900 | x | 290 | x | 720 | 78.53 | 74.75 | 80.18 | 76.4
WU990 | 900 | x | 290 | x | 900 | 96.5 | 92.72 | 98.5 | 94.72