Spreadsheet: 827670d1682948347-excel-formula-to-get-value-with-conditions-sample2
Sheet: Sheet1

PRODUCT | PRICE | turnover | RATING |  |  | PRODUCT | LOWEST 1 (L1) | Turnover (L1) | RATING (L1) | LOWEST 1 (L2) | Turnover (L2) | RATING (L2) | LOWEST 1 (L3) | Turnover (L3) | RATING (L3) | LOWEST 1 (L4) | Turnover (L4) | RATING (L4)
18063135194 | 15750 | Rs.132,985,712.00 | 4.63 |  |  | 12798105596
18063135194 | 9760.35 | [NAME] | 4.49 |  |  | 12974998375
18063135194 | 8486.15 | [NAME] | 4.61 |  |  | 18063135194
18063135194 | 15536.1 | Rs.1,957,991.50 | 4.54 |  |  | 18251773163
18063135194 | 8485.9 | Rs.335,238.48 | 4.62 |  |  | 18977886389
18063135194 | 8493.95 | Rs.335,238.48 | 4.81 |  |  | 22470826625
18063135194 | 15750 | Rs.1,110,120.00 | 4.36 |  |  | 23779790578
18063135194 | 12250 | Rs.6,428,483.00 | 5 |  |  | 24497566013
18063135194 | 15585 | Rs.1,545,776.00 | 4.63 |  |  | 31013164542
18063135194 | 15750 | Rs.14,150,850.00 | 4.58 |  |  | 48463227942
58904379732 | 14400 | Rs.132,985,712.00 | 4.63 |  |  | 58904379732
58904379732 | 13996.85 | [NAME] | 4.49 |  |  | 80255784506
58904379732 | 13928 | [NAME] | 4.61 |  |  | 80876743047
58904379732 | 13927.9 | Rs.335,238.48 | 4.62 |  |  | 85665300438
58904379732 | 13928.15 | Rs.335,238.48 | 4.81 |  |  | 87358245853
58904379732 | 14000 | Rs.1,110,120.00 | 4.36 |  |  | 89088446295
58904379732 | 14000 | Rs.1,110,120.00 | 4.2 |  |  | 9148263720
58904379732 | 14400 | Rs.6,428,483.00 | 5 |  |  | 95081141074
58904379732 | 13929.4 | Rs.1,545,776.00 | 4.63
58904379732 | 14400 | Rs.14,150,850.00 | 4.58
87358245853 | 14400 | Rs.132,985,712.00 | 4.63
87358245853 | 6890 | Rs.956,652,334.00 | 4.9
87358245853 | 14161.2 | [NAME] | 4.49
87358245853 | 13983.65 | [NAME] | 4.61
87358245853 | 6889.85 | Rs.335,238.48 | 4.62
87358245853 | 13983.95 | Rs.335,238.48 | 4.81
87358245853 | 14000 | Rs.1,110,120.00 | 4.36
87358245853 | 13984.55 | Rs.1,545,776.00 | 4.63
87358245853 | 14400 | Rs.14,150,850.00 | 4.58
48463227942 | 14400 | Rs.132,985,712.00 | 4.63
48463227942 | 14209.9 | [NAME] | 4.49
48463227942 | 13982.6 | [NAME] | 4.61
48463227942 | 13982.5 | Rs.335,238.48 | 4.62
48463227942 | 13982.8 | Rs.335,238.48 | 4.81
48463227942 | 14000 | Rs.1,110,120.00 | 4.36
48463227942 | 13984.55 | Rs.1,545,776.00 | 4.63
48463227942 | 14400 | Rs.14,150,850.00 | 4.58
18251773163 | 14400 | Rs.132,985,712.00 | 4.63
18251773163 | 14195.75 | [NAME] | 4.49
18251773163 | 9923.15 | Rs.335,238.48 | 4.62
18251773163 | 9936.800000000001 | Rs.335,238.48 | 4.81
18251773163 | 9929.400000000001 | Rs.1,545,776.00 | 4.63
18251773163 | 14400 | Rs.14,150,850.00 | 4.58
22470826625 | 15750 | Rs.132,985,712.00 | 4.63
22470826625 | 14196 | [NAME] | 4.49
22470826625 | 13687.7 | [NAME] | 4.61
22470826625 | 7375 | [NAME] | 4.37
22470826625 | 7373.95 | Rs.335,238.48 | 4.62
22470826625 | 13694.75 | Rs.335,238.48 | 4.81
22470826625 | 15750 | Rs.1,110,120.00 | 4.36
22470826625 | 13751.5 | Rs.1,575,358.67 | 4.64
22470826625 | 8632.5 | Rs.2,880,756.00 | 4.39
22470826625 | 13689.8 | Rs.1,545,776.00 | 4.63
22470826625 | 15750 | Rs.14,150,850.00 | 4.58
12798105596 | 14400 | Rs.132,985,712.00 | 4.63
12798105596 | 6875.549999999999 | Rs.3,883,100.00 | 4.5
12798105596 | 14000 | Rs.5,325,548.33 | 4.65
12798105596 | 5425 | Rs.956,652,334.00 | 4.9
12798105596 | 6296.800000000001 | [NAME] | 4.49
12798105596 | 6500 | Rs.90,785,709.50 | 4.54
12798105596 | 6489.050000000001 | [NAME] | 4.61
12798105596 | 6295.400000000001 | Rs.335,238.48 | 4.62
12798105596 | 6295.45 | Rs.335,238.48 | 4.81
12798105596 | 14400 | Rs.1,110,120.00 | 4.36
12798105596 | 14000 | Rs.1,110,120.00 | 4.98
12798105596 | 7050 | Rs.1,110,120.00 | 4.55
12798105596 | 6869.8 | Rs.1,545,776.00 | 4.63
12798105596 | 6440.65 | Rs.26,221,546.67 | 4.52
12798105596 | 14400 | Rs.14,150,850.00 | 4.58
85665300438 | 14400 | Rs.132,985,712.00 | 4.63
85665300438 | 14158.3 | [NAME] | 4.49
85665300438 | 9440.2 | [NAME] | 4.61
85665300438 | 6058.200000000001 | Rs.335,238.48 | 4.62
85665300438 | 9441.3 | Rs.335,238.48 | 4.81
85665300438 | 14250 | Rs.1,110,120.00 | 4.36
85665300438 | 7251.5 | Rs.1,575,358.67 | 4.64
85665300438 | 6060 | Rs.183,050.00 | 5
85665300438 | 12960 | [NAME] | 4.6
85665300438 | 14001.45 | Rs.26,221,546.67 | 4.52
85665300438 | 14400 | Rs.14,150,850.00 | 4.58
24497566013 | 14400 | Rs.132,985,712.00 | 4.63
24497566013 | 7549.5 | Rs.335,238.48 | 4.62
24497566013 | 7579.5 | Rs.335,238.48 | 4.81
24497566013 | 14250 | Rs.1,110,120.00 | 4.36
24497566013 | 7851.5 | Rs.1,575,358.67 | 4.64
24497566013 | 7554.049999999999 | Rs.1,545,776.00 | 4.63
24497566013 | 7545 | Rs.65,799,235.42 | 4.94
24497566013 | 14400 | Rs.14,150,850.00 | 4.58
95081141074 | 14400 | Rs.132,985,712.00 | 4.63
95081141074 | 14400 | [NAME] | 4.49
95081141074 | 6430 | Rs.38,884,461.50 | 4.56
95081141074 | 13968.25 | [NAME] | 4.49
95081141074 | 13657 | [NAME] | 4.61
95081141074 | 6438.1 | Rs.335,238.48 | 4.62
95081141074 | 13660.25 | Rs.335,238.48 | 4.81
95081141074 | 14250 | Rs.1,110,120.00 | 4.36
95081141074 | 6440 | Rs.183,050.00 | 5
95081141074 | 13550 | Rs.1,545,776.00 | 4.63
95081141074 | 14000 | Rs.5,795,482,351.50 | 4.09
95081141074 | 14400 | Rs.14,150,850.00 | 4.58
80255784506 | 14400 | Rs.132,985,712.00 | 4.63
80255784506 | 11025 | Rs.38,884,461.50 | 4.56
80255784506 | 13938.2 | [NAME] | 4.49
80255784506 | 11484 | [NAME] | 4.61
80255784506 | 11483.8 | Rs.335,238.48 | 4.62
80255784506 | 11484.35 | Rs.335,238.48 | 4.81
80255784506 | 14250 | Rs.1,110,120.00 | 4.36
80255784506 | 12816 | [NAME] | 4.6
80255784506 | 11489.6 | Rs.1,545,776.00 | 4.63
80255784506 | 14400 | Rs.14,150,850.00 | 4.58
12974998375 | 14400 | Rs.132,985,712.00 | 4.63
12974998375 | 6605.2 | Rs.3,883,100.00 | 4.5
12974998375 | 14000 | Rs.5,325,548.33 | 4.65
12974998375 | 14000 | Rs.11,408,551,036.00 | 3.47
12974998375 | 6294.449999999999 | [NAME] | 4.49
12974998375 | 6517.800000000001 | [NAME] | 4.61
12974998375 | 14400 | Rs.1,957,991.50 | 4.54
12974998375 | 6291.399999999999 | Rs.335,238.48 | 4.62
12974998375 | 6291.5 | Rs.335,238.48 | 4.81
12974998375 | 14400 | Rs.1,110,120.00 | 4.36
12974998375 | 6295 | Rs.183,050.00 | 5
12974998375 | 13500 | Rs.183,050.00 | 4.2
12974998375 | 7056 | [NAME] | 4.6
12974998375 | 6519.400000000001 | Rs.1,545,776.00 | 4.63
12974998375 | 13495 | Rs.5,795,482,351.50 | 4.09
12974998375 | 14400 | Rs.14,150,850.00 | 4.58
23779790578 | 13050 | Rs.132,985,712.00 | 4.63
23779790578 | 5075 | Rs.956,652,334.00 | 4.9
23779790578 | 11917 | [NAME] | 4.61
23779790578 | 12102.5 | Rs.2,310,951.67 | 5
23779790578 | 11916.95 | Rs.335,238.48 | 4.62
23779790578 | 11917.05 | Rs.335,238.48 | 4.81
23779790578 | 13000 | Rs.1,110,120.00 | 4.36
23779790578 | 11920 | Rs.1,545,776.00 | 4.63
23779790578 | 11920 | Rs.65,799,235.42 | 4.94
23779790578 | 13050 | Rs.14,150,850.00 | 4.58
80876743047 | 15750 | Rs.132,985,712.00 | 4.63
80876743047 | 12458.1 | [NAME] | 4.49
80876743047 | 12409.75 | Rs.335,238.48 | 4.62
80876743047 | 12409.8 | Rs.335,238.48 | 4.81
80876743047 | 15750 | Rs.1,110,120.00 | 4.36
80876743047 | 12414.95 | Rs.1,545,776.00 | 4.63
80876743047 | 15750 | Rs.14,150,850.00 | 4.58
9148263720 | 14400 | Rs.132,985,712.00 | 4.63
9148263720 | 14250 | Rs.6,372,656.67 | 4.58
9148263720 | 6221.75 | [NAME] | 4.49
9148263720 | 12100 | Rs.2,310,951.67 | 5
9148263720 | 6221.65 | Rs.335,238.48 | 4.62
9148263720 | 6222.3 | Rs.335,238.48 | 4.81
9148263720 | 14400 | Rs.1,110,120.00 | 4.36
9148263720 | 9351.5 | Rs.1,575,358.67 | 4.64
9148263720 | 6225 | Rs.183,050.00 | 5
9148263720 | 7488 | [NAME] | 4.6
9148263720 | 9341.25 | Rs.1,545,776.00 | 4.63
9148263720 | 7625 | Rs.1,545,776.00 | 4.88
9148263720 | 14400 | Rs.14,150,850.00 | 4.58
31013164542 | 15750 | Rs.132,985,712.00 | 4.63
31013164542 | 9915.5 | [NAME] | 4.49
31013164542 | 13550 | Rs.2,932,157.00 | 4.67
31013164542 | 9559.550000000001 | Rs.335,238.48 | 4.62
31013164542 | 9559.6 | Rs.335,238.48 | 4.81
31013164542 | 15650 | Rs.1,110,120.00 | 4.36
31013164542 | 9566.55 | Rs.1,545,776.00 | 4.63
31013164542 | 9890 | Rs.65,799,235.42 | 4.94
31013164542 | 15750 | Rs.14,150,850.00 | 4.58
89088446295 | 13050 | Rs.132,985,712.00 | 4.63
89088446295 | 6993.400000000001 | [NAME] | 4.61
89088446295 | 5115 | [NAME] | 4.37
89088446295 | 5113.699999999999 | Rs.335,238.48 | 4.62
89088446295 | 6861.25 | Rs.335,238.48 | 4.81
89088446295 | 13000 | Rs.1,110,120.00 | 4.36
89088446295 | 8000 | Rs.1,110,120.00 | 4.55
89088446295 | 6990.1 | Rs.1,545,776.00 | 4.63
89088446295 | 13050 | Rs.14,150,850.00 | 4.58
18977886389 | 13050 | Rs.132,985,712.00 | 4.63
18977886389 | 6668.75 | Rs.3,883,100.00 | 4.5
18977886389 | 13000 | Rs.11,408,551,036.00 | 3.47
18977886389 | 6617.349999999999 | [NAME] | 4.61
18977886389 | 13050 | Rs.2,932,157.00 | 4.67
18977886389 | 6526.599999999999 | Rs.335,238.48 | 4.62
18977886389 | 6617.4 | Rs.335,238.48 | 4.81
18977886389 | 13000 | Rs.1,110,120.00 | 4.36
18977886389 | 6528.55 | Rs.1,545,776.00 | 4.63
18977886389 | 13050 | Rs.14,150,850.00 | 4.58