Spreadsheet: 705833d1606323391-return-the-value-of-cell-based-from-2-criterias-sample-1
Sheet: Salary

BASIC_NEW | New Basic | Level | Grade
4500 | 4870
4500 | 4870
4625 | 4890
4870 | 5240
4870 | 5240
4870 | 5240
4870 | 5240
5240 | 5610
5240 | 5610
5240 | 5610
5240 | 5610
5240 | 5610
5240 | 5610
5240 | 5610
5240 | 5610
5240 | 5610
5240 | 5610
5240 | 5610
5300 | 5600
5610 | 5980
5610 | 5980
5610 | 5980
5610 | 5980
5610 | 5980
5610 | 5980
5610 | 5980
5610 | 5980
5610 | 5980
5675 | 6010
5685 | 5950
5700 | 6105
5980 | 6350
5980 | 6350
5980 | 6350
5980 | 6350
5980 | 6350
5980 | 6350
5980 | 6350
5980 | 6350
5980 | 6350
5980 | 6350
5980 | 6350
5980 | 6350
5980 | 6350
5980 | 6350
5980 | 6350
5980 | 6350
5980 | 6350
5980 | 6350
6010 | 6345
6010 | 6345
6010 | 6345
6105 | 6510
6345 | 6680
6345 | 6680
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6350 | 6720
6480 | 6745
6480 | 6745
6680 | 7015
6680 | 7015
6680 | 7015
6700 | 7140
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
6720 | 7090
7015 | 7350
7090 | 7460
7090 | 7460
7090 | 7460
7090 | 7460
7090 | 7460
7090 | 7460
7090 | 7460
7090 | 7460
7090 | 7460
7090 | 7460
7090 | 7460
7090 | 7460
7090 | 7460
7090 | 7460
7090 | 7460
7090 | 7460
7090 | 7460
7090 | 7460
7090 | 7460
7090 | 7460
7090 | 7460
7090 | 7460
7090 | 7460
7090 | 7460
7090 | 7460
7090 | 7460
7090 | 7460
7090 | 7460
7090 | 7460
7090 | 7460
7090 | 7460
7090 | 7460
7090 | 7460
7090 | 7460
7090 | 7460
7090 | 7460
7090 | 7460
7090 | 7460
7090 | 7460
7090 | 7460
7090 | 7460
7140 | 7580
7140 | 7580
7275 | 7540
7350 | 7685
7350 | 7685
7350 | 7685
7460 | 7830
7460 | 7830
7460 | 7830
7460 | 7830
7460 | 7830
7460 | 7830
7460 | 7830
7460 | 7830
7460 | 7830
7460 | 7830
7460 | 7830
7460 | 7830
7460 | 7830
7460 | 7830
7460 | 7830
7460 | 7830
7460 | 7830
7460 | 7830
7460 | 7830
7460 | 7830
7460 | 7830
7460 | 7830
7460 | 7830
7460 | 7830
7460 | 7830
7460 | 7830
7460 | 7830
7460 | 7830
7460 | 7830
7460 | 7830
7460 | 7830
7460 | 7830
7460 | 7830
7460 | 7830
7460 | 7830
7460 | 7830
7460 | 7830
7460 | 7830
7540 | 7805
7540 | 7805
7540 | 7805
7540 | 7805
7580 | 8020
7580 | 8020
7580 | 8020
7580 | 8020
7580 | 8020
7580 | 8020
7580 | 8020
7580 | 8020
7580 | 8020
7580 | 8020
7580 | 8020
7580 | 8020
7685 | 8020
7685 | 8020
7685 | 8020
7685 | 8020
7725 | 8130
7725 | 8130
7725 | 8130
7725 | 8130
7725 | 8130
7725 | 8130
7725 | 8130
7725 | 8130
7805 | 8070
7805 | 8070
7830 | 8200
7830 | 8200
7830 | 8200
7830 | 8200
7830 | 8200
7830 | 8200
7830 | 8200
7830 | 8200
7830 | 8200
7830 | 8200
7830 | 8200
7830 | 8200
7830 | 8200
8020 | 8460
8020 | 8460
8020 | 8460
8020 | 8460
8020 | 8460
8020 | 8460
8020 | 8460
8020 | 8460
8060 | 8290
8070 | 8335
8070 | 8335
8130 | 8535
8130 | 8535
8130 | 8535
8130 | 8535
8130 | 8535
8130 | 8535
8130 | 8535
8130 | 8535
8130 | 8535
8200 | 8675
8200 | 8675
8200 | 8675
8200 | 8675
8200 | 8675
8200 | 8675
8200 | 8675
8200 | 8675
8200 | 8675
8200 | 8675
8200 | 8675
8200 | 8675
8200 | 8675
8200 | 8675
8200 | 8675
8200 | 8675
8335 | 8600
8335 | 8600
8335 | 8600
8355 | 8690
8460 | 8900
8460 | 8900
8460 | 8900
8460 | 8900
8520 | 8750
8535 | 8940
8535 | 8940
8535 | 8940
8535 | 8940
8535 | 8940
8535 | 8940
8535 | 8940
8535 | 8940
8535 | 8940
8535 | 8940
8535 | 8940
8535 | 8940
8535 | 8940
8535 | 8940
8535 | 8940
8535 | 8940
8535 | 8940
8570 | 8940
8570 | 8940
8570 | 8940
8570 | 8940
8570 | 8940
8570 | 8940
8570 | 8940
8570 | 8940
8570 | 8940
8570 | 8940
8570 | 8940
8570 | 8940
8570 | 8940
8570 | 8940
8570 | 8940
8570 | 8940
8570 | 8940
8570 | 8940
8570 | 8940
8570 | 8940
8570 | 8940
8690 | 9025
8690 | 9025
8690 | 9025
8900 | 9340
8900 | 9340
8900 | 9340
8900 | 9340
8900 | 9340
8900 | 9340
8900 | 9340
8900 | 9340
8900 | 9340
8900 | 9340
8900 | 9340
8900 | 9340
8900 | 9340
8900 | 9340
8940 | 9345
8940 | 9345
8940 | 9345
8940 | 9345
8940 | 9345
8940 | 9345
8940 | 9345
8940 | 9345
8940 | 9345
8940 | 9345
8940 | 9345
8940 | 9345
8940 | 9345
8940 | 9345
8940 | 9345
8940 | 9345
8940 | 9345
8940 | 9345
8940 | 9345
8940 | 9345
8940 | 9345
8940 | 9345
8940 | 9345
8940 | 9345
8940 | 9345
8940 | 9345
8940 | 9345
8940 | 9345
8940 | 9345
8940 | 9345
8940 | 9345
8940 | 9345
8940 | 9345
8970 | #[NAME]!
9025 | 9360
9130 | 9395
9130 | 9395
9130 | 9395
9130 | 9395
9150 | 9625
9150 | 9625
9310 | 9680
9310 | 9680
9310 | 9680
9310 | 9680
9310 | 9680
9310 | 9680
9310 | 9680
9310 | 9680
9310 | 9680
9310 | 9680
9310 | 9680
9310 | 9680
9310 | 9680
9310 | 9680
9340 | 9780
9340 | 9780
9340 | 9780
9340 | 9780
9340 | 9780
9340 | 9780
9340 | 9780
9340 | 9780
9340 | 9780
9340 | 9780
9340 | 9780
9340 | 9780
9340 | 9780
9340 | 9780
9340 | 9780
9340 | 9780
9340 | 9780
9340 | 9780
9340 | 9780
9340 | 9780
9340 | 9780
9340 | 9780
9340 | 9780
9340 | 9780
9340 | 9780
9340 | 9780
9340 | 9780
9340 | 9780
9340 | 9780
9340 | 9780
9340 | 9780
9340 | 9780
9340 | 9780
9340 | 9780
9340 | 9780
9340 | 9780
9340 | 9780
9340 | 9780
9340 | 9780
9340 | 9780
9345 | 9750
9345 | 9750
9345 | 9750
9345 | 9750
9345 | 9750
9345 | 9750
9345 | 9750
9345 | 9750
9345 | 9750
9345 | 9750
9345 | 9750
9345 | 9750
9345 | 9750
9345 | 9750
9345 | 9750
9360 | 9695
9395 | 9660
9395 | 9660
9395 | 9660
9395 | 9660
9625 | 10100
9660 | 9925
9660 | 9925
9680 | 10050
9680 | 10050
9680 | 10050
9680 | 10050
9680 | 10050
9680 | 10050
9680 | 10050
9680 | 10050
9680 | 10050
9680 | 10050
9695 | 10030
9750 | 10155
9750 | 10155
9750 | 10155
9750 | 10155
9750 | 10155
9750 | 10155
9750 | 10155
9750 | 10155
9750 | 10155
9750 | 10155
9780 | 10220
9780 | 10220
9780 | 10220
9780 | 10220
9780 | 10220
9780 | 10220
9780 | 10220
9780 | 10220
9780 | 10220
9780 | 10220
9780 | 10220
9780 | 10220
9780 | 10220
9780 | 10220
9780 | 10220
9780 | 10220
9780 | 10220
9780 | 10220
9780 | 10220
9780 | 10220
9780 | 10220
9780 | 10220
9780 | 10220
9780 | 10220
9780 | 10220
9780 | 10220
9780 | 10220
9780 | 10220
9780 | 10220
9780 | 10220
9780 | 10220
9780 | 10220
9780 | 10220
10030 | 10365
10030 | 10365
10043 | #[NAME]!
10050 | 10420
10050 | 10420
10050 | 10420
10050 | 10420
10050 | 10420
10050 | 10420
10100 | 10575
10100 | 10575
10155 | 10560
10155 | 10560
10155 | 10560
10155 | 10560
10155 | 10560
10155 | 10560
10155 | 10560
10155 | 10560
10155 | 10560
10155 | 10560
10220 | 10660
10220 | 10660
10220 | 10660
10220 | 10660
10220 | 10660
10220 | 10660
10220 | 10660
10220 | 10660
10220 | 10660
10220 | 10660
10220 | 10660
10220 | 10660
10220 | 10660
10220 | 10660
10220 | 10660
10220 | 10660
10220 | 10660
10220 | 10660
10220 | 10660
10220 | 10660
10220 | 10660
10220 | 10660
10220 | 10660
10220 | 10660
10220 | 10660
10220 | 10660
10220 | 10660
10220 | 10660
10220 | 10660
10220 | 10660
10220 | 10660
10220 | 10660
10365 | 10700
10400 | 10700
10400 | 10700
10400 | 10700
10400 | 10700
10400 | 10700
10420 | 10790
10420 | 10790
10420 | 10790
10420 | 10790
10520 | #[NAME]!
10560 | 10965
10560 | 10965
10560 | 10965
10560 | 10965
10560 | 10965
10560 | 10965
10560 | 10965
10560 | 10965
10560 | 10965
10575 | 11050
10660 | 11100
10660 | 11100
10660 | 11100
10660 | 11100
10660 | 11100
10660 | 11100
10660 | 11100
10660 | 11100
10660 | 11100
10660 | 11100
10660 | 11100
10660 | 11100
10660 | 11100
10660 | 11100
10660 | 11100
10660 | 11100
10660 | 11100
10700 | 11035
10700 | 11035
10700 | 11035
10700 | 11035
10790 | 11160
10790 | 11160
10790 | 11160
10790 | 11160
10790 | 11160
10790 | 11160
10960 | #[NAME]!
10965 | 11370
10965 | 11370
10965 | 11370
10965 | 11370
10965 | 11370
10965 | 11370
10965 | 11370
10965 | 11370
11035 | 11370
11035 | 11370
11035 | 11370
11035 | 11370
11050 | 11525
11050 | 11525
11100 | 11540
11100 | 11540
11100 | 11540
11100 | 11540
11100 | 11540
11100 | 11540
11100 | 11540
11100 | 11540
11100 | 11540
11100 | 11540
11100 | 11540
11100 | 11540
11100 | 11540
11100 | 11540
11100 | 11540
11100 | 11540
11100 | 11540
11100 | 11540
11100 | 11540
11100 | 11540
11100 | 11540
11100 | 11540
11100 | 11540
11160 | 11530
11160 | 11530
11160 | 11530
11160 | 11530
11160 | 11530
11160 | 11530
11160 | 11530
11370 | 11775
11370 | 11775
11370 | 11775
11370 | 11775
11370 | 11775
11370 | 11775
11370 | 11775
11520 | 12030
11525 | 12000
11530 | 11900
11530 | 11900
11530 | 11900
11530 | 11900
11530 | 11900
11530 | 11900
11530 | 11900
11540 | 11980
11540 | 11980
11540 | 11980
11540 | 11980
11540 | 11980
11540 | 11980
11540 | 11980
11540 | 11980
11540 | 11980
11540 | 11980
11540 | 11980
11540 | 11980
11540 | 11980
11540 | 11980
11540 | 11980
11540 | 11980
11540 | 11980
11540 | 11980
11540 | 11980
11540 | 11980
11540 | 11980
11540 | 11980
11540 | 11980
11540 | 11980
11540 | 11980
11775 | 12180
11775 | 12180
11775 | 12180
11775 | 12180
11775 | 12180
11775 | 12180
11775 | 12180
11775 | 12180
11900 | 12270
11900 | 12270
11900 | 12270
11980 | 12420
11980 | 12420
11980 | 12420
11980 | 12420
11980 | 12420
11980 | 12420
11980 | 12420
11980 | 12420
11980 | 12420
11980 | 12420
11980 | 12420
11980 | 12420
11980 | 12420
11980 | 12420
11980 | 12420
11980 | 12420
11980 | 12420
11980 | 12420
12000 | 12475
12000 | 12475
12180 | 12585
12180 | 12585
12180 | 12585
12270 | 12640
12270 | 12640
12270 | 12640
12420 | 12860
12420 | 12860
12420 | 12860
12420 | 12860
12420 | 12860
12420 | 12860
12420 | 12860
12420 | 12860
12420 | 12860
12420 | 12860
12420 | 12860
12420 | 12860
12420 | 12860
12420 | 12860
12420 | 12860
12420 | 12860
12420 | 12860
12420 | 12860
12475 | 12950
12475 | 12950
12475 | 12950
12540 | 13050
12540 | 13050 |  |  |  | IF($B826>$A826,INDEX('Admin Scale'!$A$1:$A$12,AGGREGATE(14,6,(ROW('Admin Scale'!$A$1:$Z$12)/($B826='Admin Scale'!$A$1:$Z$12)),1)),INDEX('Admin Scale'!$A$1:$A$12,AGGREGATE(14,6,(ROW('Admin Scale'!$A$1:$Z$12)/($A826='Admin [NAME])))
12585 | 12990 |  |  |  | IF($B826>$A826,INDEX('Admin Scale'!$A$1:$A$12,AGGREGATE(14,6,(COLUMN('Admin Scale'!$A$1:$Z$12)/($B826='Admin Scale'!$A$1:$Z$12)),1)),INDEX('Admin Scale'!$A$1:$A$12,AGGREGATE(14,6,(COLUMN('Admin Scale'!$A$1:$Z$12)/($A826='Admin [NAME])))
12585 | 12990
12585 | 12990
12640 | 13010
12640 | 13010
12640 | 13010
12640 | 13010
12640 | 13010
12640 | 13010
12640 | 13010
12860 | 13300
12860 | 13300
12860 | 13300
12860 | 13300
12860 | 13300
12860 | 13300
12860 | 13300
12860 | 13300
12860 | 13300
12860 | 13300
12860 | 13300
12860 | 13300
12860 | 13300
12860 | 13300
12860 | 13300
12860 | 13300
12860 | 13300
12860 | 13300
12950 | 13425
12950 | 13425
12950 | 13425
12950 | 13425
12950 | 13425
12990 | 13395
13010 | 13380
13010 | 13380
13300 | 13740
13300 | 13740
13300 | 13740
13300 | 13740
13300 | 13740
13300 | 13740
13300 | 13740
13300 | 13740
13300 | 13740
13300 | 13740
13300 | 13740
13300 | 13740
13300 | 13740
13300 | 13740
13380 | 13750
13380 | 13750
13380 | 13750
13380 | 13750
13395 | 13800
13740 | 14180
13740 | 14180
13740 | 14180
13740 | 14180
13740 | 14180
13740 | 14180
13740 | 14180
13740 | 14180
13740 | 14180
13740 | 14180
13800 | 14205
13800 | 14205
13800 | 14205
13800 | 14205
14180 | 14620
14180 | 14620
14180 | 14620
14180 | 14620
14180 | 14620
14180 | 14620
14180 | 14620
14180 | 14620
14180 | 14620
14180 | 14620
14180 | 14620
14205 | 14610
14375 | 14850
14375 | 14850
14610 | 15015
14610 | 15015
14610 | 15015
14620 | 15060
14620 | 15060
14620 | 15060
14620 | 15060
14620 | 15060
14620 | 15060
14850 | 15325
15015 | 15420
15015 | 15420
15015 | 15420
15015 | 15420
15060 | 15500
15060 | 15500
15060 | 15500
15060 | 15500
15060 | 15500
15060 | 15500
15060 | 15500
15060 | 15500
15090 | 15600
15090 | 15600
15420 | 15825
15420 | 15825
15420 | 15825
15420 | 15825
15420 | 15825
15500 | 15940
15500 | 15940
15500 | 15940
15500 | 15940
15500 | 15940
15800 | 16275
15800 | 16275
15800 | 16275
15800 | 16275
15940 | 16380
15940 | 16380
15940 | 16380
15940 | 16380
15940 | 16380
15940 | 16380
15940 | 16380
16110 | 16620
16110 | 16620
16200 | 16740
16380 | 16820
16380 | 16820
16380 | 16820
16380 | 16820
16820 | 17260
16820 | 17260
16820 | 17260
16820 | 17260
16820 | 17260
17130 | 17640
17225 | 17700
17260 | 17700
17260 | 17700
17260 | 17700
17260 | 17700
17700 | 18175
17700 | 18175
18175 | 18650
18175 | 18650
18175 | 18650
18175 | 18650
18360 | 18900
18360 | 18900
18650 | 19125
18650 | 19125
18650 | 19125
18650 | 19125
18650 | 19125
18650 | 19125
18650 | 19125
19125 | 19600
19125 | 19600
19125 | 19600
19440 | 19980
19440 | 19980
19440 | 19980
19600 | 20075
19600 | 20075
19600 | 20075
19600 | 20075
20190 | 20700
20190 | 20700
20700 | 21210
20700 | 21210
20700 | 21210
21210 | 21720
21720 | 22230
22230 | 22740
24300 | 24840
24300 | 24840
24300 | 24840
24840 | 25380
26050 | 26625
26460 | 27000
27775 | 28350
28350 | 28925
31800 | over scale
31800 | over scale
38160 | #[NAME]!
42822 | #[NAME]!
61025 | #[NAME]!