Spreadsheet: 93230d1292852353-lookup-multiple-values-in-multiple-columns-and-return-value-example
Sheet: Ark2

P | Q | S
101 | 210 | 0
101 | 25 | 0
101 | 60 | 0
103 | 210 | 0
103 | 25 | 5
103 | 60 | 0
11136 | 1 | 0
11136 | 1000 | 0
11136 | 210 | 0
11136 | 25 | 0
11136 | 5 | 0
11136 | 60 | 0
11147 | 1 | 0
11147 | 1000 | 0
11147 | 210 | 0
11147 | 25 | 0
11147 | 5 | 0
11147 | 60 | 0
11236 | 1000 | 0
11236 | 210 | 1
11236 | 25 | 0
11236 | 60 | 0
11247 | 1000 | 0
11247 | 210 | 0
11247 | 25 | 0
11247 | 60 | 0
1125 | 1000 | 0
1125 | 210 | 0
1125 | 25 | 0
1125 | 60 | 0
1136 | 1 | 0
1136 | 1000 | 0
1136 | 210 | 0
1136 | 25 | 0
1136 | 5 | 0
1136 | 60 | 0
1147 | 1000 | 0
1147 | 210 | 0
1147 | 25 | 0
1147 | 60 | 0
1215 | 1000 | 0
1215 | 210 | 0
1215 | 25 | 0
1215 | 60 | 0
1216 | 1000 | 0
1216 | 210 | 0
1216 | 25 | 0
1216 | 60 | 0
1227 | 1000 | 0
1227 | 210 | 0
1227 | 25 | 2
1227 | 60 | 0
1236 | 1000 | 0
1236 | 210 | 1
1236 | 25 | 0
1236 | 5 | 0
1236 | 60 | 0
1237 | 1000 | 0
1237 | 210 | 0
1237 | 25 | 0
1237 | 60 | 0
1247 | 1000 | 0
1247 | 210 | 0
1247 | 25 | 0
1247 | 5 | 0
1247 | 60 | 0
13125 | 1000 | 0
13125 | 210 | -1
13125 | 25 | 0
13125 | 60 | 0
13236 | 1000 | 0
13236 | 210 | 0
13236 | 25 | 0
13236 | 60 | 0
13336 | 1000 | 0
13336 | 210 | 2
13336 | 25 | 0
13336 | 60 | 0
13526 | 1000 | 0
13526 | 210 | 0
13526 | 25 | 0
13526 | 60 | 0
13536 | 1000 | 0
13536 | 210 | 0
13536 | 25 | 0
13536 | 60 | 0
1406 | 1 | 0
1406 | 1000 | 0
1406 | 210 | 0
1406 | 25 | 0
1406 | 60 | 0
14105 | 1 | 0
14105 | 1000 | 0
14105 | 210 | 0
14105 | 25 | 0
14105 | 60 | 0
14115 | 1 | 0
14115 | 1000 | 0
14115 | 210 | 0
14115 | 25 | 0
14115 | 5 | 44
14115 | 60 | 0
14116 | 1 | 43
14116 | 1000 | 0
14116 | 210 | 5
14116 | 25 | 5
14116 | 5 | 53
14116 | 60 | 6
14136 | 1 | 49
14136 | 1000 | 0
14136 | 210 | 3
14136 | 25 | 0
14136 | 4 | 18
14136 | 5 | 17
14136 | 60 | 1
14138 | 1000 | 0
14138 | 210 | 0
14138 | 25 | 0
14138 | 60 | 0
14147 | 1 | 0
14147 | 1000 | 0
14147 | 210 | 0
14147 | 25 | 0
14147 | 5 | 0
14147 | 60 | 0
1425 | 1000 | 0
1425 | 210 | 2
1425 | 25 | 0
1425 | 60 | 0
1426 | 1000 | 0
1426 | 210 | 2
1426 | 25 | 0
1426 | 60 | 0
1435 | 1000 | 0
1435 | 210 | 0
1435 | 25 | 5
1435 | 60 | 0
1436 | 1000 | 0
1436 | 210 | 0
1436 | 25 | 0
1436 | 60 | 0
14626 | 1000 | 1
14626 | 210 | 9
14626 | 25 | 6
14626 | 60 | 0
14636 | 1000 | 0
14636 | 210 | 5
14636 | 25 | 15
14636 | 5 | 12
14636 | 60 | 0
1503 | 1 | 92
1503 | 1000 | 0
1503 | 210 | 0
1503 | 25 | 2
1503 | 5 | 12
1503 | 60 | 2
15104 | 1000 | 0
15104 | 210 | 0
15104 | 25 | 0
15104 | 60 | 0
15106 | 1 | 0
15106 | 1000 | 0
15106 | 210 | 0
15106 | 25 | 0
15106 | 5 | 0
15106 | 60 | 0
15115 | 1 | 0
15115 | 1000 | 0
15115 | 210 | 0
15115 | 25 | 0
15115 | 60 | 0
15116 | 1000 | 0
15116 | 210 | 0
15116 | 25 | 0
15116 | 60 | 0
15736 | 1000 | 0
15736 | 210 | 0
15736 | 25 | 0
15736 | 60 | 0
1627 | 1000 | 0
1627 | 210 | 0
1627 | 25 | 5
1627 | 60 | 0
1726 | 1000 | 0
1726 | 210 | 0
1726 | 25 | 0
1726 | 60 | 0
1900 | 1 | 0
1900 | 1000 | 0
1900 | 210 | 0
1900 | 25 | 0
1900 | 60 | 0
1905 | 1 | 35
1905 | 1000 | 0
1905 | 210 | 0
1905 | 25 | 0
1905 | 60 | 0
1908 | 1 | 20
1908 | 1000 | 0
1908 | 210 | 0
1908 | 25 | 0
1908 | 5 | 0
1908 | 60 | 0
1909 | 1 | 0
1909 | 1000 | 0
1909 | 210 | 0
1909 | 25 | 0
1909 | 60 | 0
1912 | 1 | 39
1912 | 1000 | 0
1912 | 210 | 0
1912 | 25 | 0
1912 | 5 | 0
1912 | 60 | 0
21116 | 1 | 36
21116 | 1000 | 0
21116 | 210 | 4
21116 | 25 | 0
21116 | 5 | 44
21116 | 60 | 2
2201 | 1000 | 0
2201 | 210 | 0
2201 | 25 | 0
2201 | 60 | 0
2208 | 1 | 0
2208 | 1000 | 0
2208 | 210 | 0
2208 | 25 | 0
2208 | 60 | 0
2209 | 1 | 20
2209 | 1000 | 0
2209 | 210 | 0
2209 | 25 | 0
2209 | 5 | 0
2209 | 60 | 0
2211 | 1000 | 0
2211 | 210 | 0
2211 | 25 | 0
2211 | 60 | 0
2212 | 210 | 0
2300 | 1 | 20
2300 | 1000 | 0
2300 | 210 | 0
2300 | 25 | 0
2300 | 60 | 0
2305 | 1 | 27
2305 | 1000 | 0
2305 | 210 | 2
2305 | 25 | 3
2305 | 5 | 43
2305 | 60 | 0
2306 | 1 | 15
2306 | 1000 | 0
2306 | 210 | 0
2306 | 25 | 2
2306 | 60 | 1
2307 | 210 | 0
2308 | 1 | 39
2308 | 1000 | 0
2308 | 210 | 1
2308 | 25 | 0
2308 | 5 | 36
2308 | 60 | 4
2309 | 1000 | 0
2309 | 210 | 2
2309 | 25 | 0
2309 | 60 | 0
2312 | 1000 | 0
2312 | 210 | 0
2312 | 25 | 0
2312 | 60 | 0
23121 | 210 | 1
23127 | 1 | 61
23127 | 1000 | 0
23127 | 210 | 5
23127 | 25 | 4
23127 | 5 | 34
23127 | 60 | 2
2408 | 1000 | 0
2408 | 210 | 0
2408 | 25 | 7
2408 | 60 | 0
2410 | 1000 | 0
2410 | 210 | 0
2410 | 25 | 0
2410 | 60 | 0
24125 | 1000 | 0
24125 | 210 | 0
24125 | 25 | 0
24125 | 60 | 0
27117 | 1 | 14
27117 | 1000 | 0
27117 | 210 | 0
27117 | 25 | 0
27117 | 60 | 0
27118 | 1000 | 0
27118 | 210 | 0
27118 | 25 | 0
27118 | 60 | 0
28115 | 210 | 2
29081 | 1 | 37
29081 | 1000 | 0
29081 | 210 | 0
29081 | 25 | 3
29081 | 5 | -112
29081 | 60 | 0
29115 | 1000 | 0
29115 | 210 | 2
29115 | 25 | 0
29115 | 60 | 0
3002 | 1000 | 0
3002 | 210 | 0
3002 | 25 | 0
3002 | 60 | 0
3003 | 1 | 0
3003 | 1000 | 0
3003 | 210 | 0
3003 | 25 | 0
3003 | 5 | 0
3003 | 60 | 0
3006 | 1 | 22
3006 | 1000 | 0
3006 | 210 | 5
3006 | 25 | 4
3006 | 5 | 22
3006 | 60 | 1
3010 | 1000 | 0
3010 | 210 | 0
3010 | 25 | 0
3010 | 60 | 0
3120 | 1000 | 0
3120 | 210 | 0
3120 | 25 | 0
3120 | 60 | 0
3121 | 1000 | 1
3121 | 210 | 1
3121 | 25 | 0
3121 | 60 | 0
3122 | 1000 | 0
3122 | 210 | 0
3122 | 25 | 0
3122 | 60 | 0
3123 | 1000 | 0
3123 | 210 | 0
3123 | 25 | 0
3123 | 60 | 0
4000 | 1000 | 0
4000 | 210 | 0
4000 | 25 | 0
4000 | 60 | 0
4001 | 1000 | 0
4001 | 210 | 0
4001 | 25 | 0
4001 | 60 | 0
4002 | 1000 | 0
4002 | 210 | 0
4002 | 25 | 0
4002 | 60 | 0
4004 | 1000 | 0
4004 | 210 | 0
4004 | 25 | 0
4004 | 60 | 0
4005 | 1000 | 0
4005 | 210 | 1
4005 | 25 | 2
4005 | 60 | 3
4006 | 1 | 0
4006 | 1000 | 0
4006 | 210 | 2
4006 | 25 | 8
4006 | 5 | 0
4006 | 60 | 1
4007 | 1000 | 0
4007 | 210 | 0
4007 | 25 | 0
4007 | 60 | 0
4008 | 1000 | 0
4008 | 210 | 1
4008 | 25 | 0
4008 | 60 | 0
4009 | 1000 | 0
4009 | 210 | 0
4009 | 25 | 0
4009 | 60 | 0
4010 | 1000 | 0
4010 | 210 | 0
4010 | 25 | 0
4010 | 60 | 0
4015 | 1000 | 0
4015 | 210 | 0
4015 | 25 | 0
4015 | 60 | 0
4106 | 1000 | 0
4106 | 210 | 0
4106 | 25 | 0
4106 | 60 | 0
4107 | 1000 | 0
4107 | 210 | 0
4107 | 25 | 0
4107 | 60 | 0
4108 | 1000 | 0
4108 | 210 | 0
4108 | 25 | 0
4108 | 60 | 0
4109 | 1000 | 0
4109 | 210 | 0
4109 | 25 | 0
4109 | 60 | 0
4110 | 1000 | 0
4110 | 210 | 0
4110 | 25 | 0
4110 | 60 | 0
4111 | 1000 | 0
4111 | 210 | 0
4111 | 25 | 0
4111 | 60 | 0
4112 | 1000 | 0
4112 | 210 | 0
4112 | 25 | 0
4112 | 60 | 0
4204 | 1000 | 0
4204 | 210 | 0
4204 | 25 | 0
4204 | 60 | 0
4205 | 1000 | 0
4205 | 210 | 0
4205 | 25 | 0
4205 | 60 | 0
4206 | 1000 | 0
4206 | 210 | 0
4206 | 25 | 0
4206 | 60 | 0
4207 | 1000 | 0
4207 | 210 | 0
4207 | 25 | 1
4207 | 60 | 0
4208 | 1000 | 0
4208 | 210 | 0
4208 | 25 | 0
4208 | 60 | 0
4209 | 1000 | 0
4209 | 210 | 0
4209 | 25 | 0
4209 | 60 | 0
4210 | 1000 | 0
4210 | 210 | 0
4210 | 25 | 4
4210 | 60 | 0
4211 | 1000 | 0
4211 | 210 | 0
4211 | 25 | 0
4211 | 60 | 0
4403 | 1000 | 0
4403 | 210 | 0
4403 | 25 | 0
4403 | 60 | 0
4404 | 1000 | 0
4404 | 210 | 0
4404 | 25 | 0
4404 | 60 | 0
4405 | 1000 | 0
4405 | 210 | 0
4405 | 25 | 1
4405 | 60 | 0
4406 | 1000 | 2
4406 | 210 | 3
4406 | 25 | 12
4406 | 60 | 6
4407 | 1000 | 0
4407 | 210 | 0
4407 | 25 | 0
4407 | 60 | 0
4408 | 1000 | 0
4408 | 210 | 0
4408 | 25 | 0
4408 | 60 | 0
4522 | 1000 | 0
4522 | 210 | 0
4522 | 25 | 0
4522 | 60 | 0
4526 | 210 | 0
4526 | 25 | 0
4526 | 60 | 0
4530 | 1000 | 0
4530 | 210 | 0
4530 | 25 | 0
4530 | 60 | 0
4531 | 1000 | 0
4531 | 210 | 0
4531 | 25 | 0
4531 | 60 | 0
4532 | 1000 | 0
4532 | 210 | 0
4532 | 25 | 0
4532 | 60 | 0
4533 | 1000 | 0
4533 | 210 | 0
4533 | 25 | 0
4533 | 60 | 0
4534 | 1000 | 0
4534 | 210 | 0
4534 | 25 | 0
4534 | 60 | 0
5070 | 1000 | 0
5070 | 210 | 0
5070 | 25 | 0
5070 | 60 | 0
5078 | 1 | 40
5502 | 210 | 2
5502 | 25 | 10
5502 | 60 | 0
65603 | 1000 | 2
65603 | 210 | 6
65603 | 25 | 15
65603 | 60 | 0
65604 | 1 | 66
65604 | 1000 | 0
65604 | 210 | 7
65604 | 25 | 3
65604 | 5 | 35
65604 | 60 | 5
65605 | 1000 | 0
65605 | 210 | 1
65605 | 25 | 0
65605 | 60 | 1
65606 | 1000 | 0
65606 | 210 | 4
65606 | 25 | 0
65606 | 60 | 0
65607 | 210 | 10
65607 | 25 | 5
65607 | 60 | 2
65608 | 1000 | 0
65608 | 210 | 0
65608 | 25 | 0
65608 | 60 | 1
65609 | 1000 | 0
65609 | 210 | 0
65609 | 25 | 0
65609 | 60 | 0
65610 | 1000 | 0
65610 | 210 | 0
65610 | 25 | 1
65610 | 60 | 0
73010 | 1000 | 0
73010 | 210 | 0
73010 | 25 | 0
73010 | 60 | 0
836 | 1 | 0
836 | 1000 | 0
836 | 210 | 0
836 | 25 | 0
836 | 5 | 0
836 | 60 | 0
847 | 1 | 0
847 | 1000 | 0
847 | 210 | 0
847 | 25 | 0
847 | 5 | 0
847 | 60 | 0
9000 | 1 | 0
9000 | 10 | 0
9000 | 18 | 0
9000 | 180 | 0
9000 | 400 | 24
9000 | 5 | 0
9000 | 50 | 4
9003 | 1 | 0
9003 | 10 | 0
9003 | 18 | 0
9003 | 180 | 0
9003 | 400 | 0
9003 | 5 | 0
9003 | 50 | 0
9015 | 1 | 0
9015 | 10 | 0
9015 | 18 | 0
9015 | 180 | 0
9015 | 400 | 0
9015 | 5 | 0
9020 | 1 | 0
9020 | 10 | 0
9020 | 18 | 0
9020 | 180 | 0
9020 | 400 | 72
9020 | 5 | 0
9020 | 50 | 0
9026 | 1 | 0
9026 | 10 | 0
9026 | 18 | 0
9026 | 180 | 0
9026 | 5 | 0
9026 | 50 | 0
9030 | 1 | 0
9030 | 10 | 0
9030 | 18 | 0
9030 | 180 | 0
9030 | 400 | 96
9030 | 5 | 0
9030 | 50 | 0
9040 | 1 | 0
9040 | 10 | 0
9040 | 18 | 0
9040 | 180 | 0
9040 | 400 | 0
9040 | 5 | 0
9040 | 50 | 0
9041 | 1 | 0
9041 | 10 | 0
9041 | 18 | 0
9041 | 180 | 0
9041 | 400 | 71
9041 | 5 | 0
9041 | 50 | 4
9050 | 1 | 0
9050 | 10 | 0
9050 | 18 | 0
9050 | 180 | 0
9050 | 400 | 0
9050 | 5 | 0
9050 | 50 | 0
9080 | 1 | 0
9080 | 10 | 0
9080 | 18 | 1
9080 | 180 | 0
9080 | 5 | 0
9080 | 50 | 0
9081 | 1 | 0
9081 | 10 | 0
9081 | 18 | 0
9081 | 180 | 0
9081 | 5 | 0
9081 | 50 | 0
9082 | 1 | 0
9082 | 10 | 0
9082 | 18 | 0
9082 | 180 | 0
9082 | 5 | 0
9082 | 50 | 0
9083 | 1 | 0
9083 | 18 | 0
9083 | 400 | 0
9083 | 5 | 0
Totalt |  | 1470