Spreadsheet: 885331d1734822965-index-match-depending-on-multiples-values-from-multiples-drop-down-lists-and-columns-index-match-if-or-switch-function-in-table-without-sensitive
Sheet: RESULTS

 |  |  |  |  |  |  |  |  |  |  |  |  |  | ACTUAL RESULTS |  |  |  |  |  |  |  |  |  |  |  |  |  | EXPECTED RESULTS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RM |  |  |  |  |  |  |  |  |  |  |  |  |  | RM |  |  |  | RM
 |  |  |  |  |  |  |  |  |  |  |  |  |  | RM | MIN | MAX |  |  | MIN | MAX |  |  | MIN | MAX |  |  |  | RM
Column2 | Column3 | Column4 | Column5 | Column1 | Column6 | Column7 | [NAME]. | Column8 | Column9 |  |  |  |  | Column1 | VALUES DEPENDING ON WHAT I CHOOSE IN CELL P2 or Q2 or P3 and there will be always one of them which won't be blank | Column3 | Column34 | Column4 | Column32 | Column33 | Column332 | Column333 | Column5 | Column6 | Column3322 | Column3333 |  | Column1 | Column2 | Column3 | Column34 | Column4 | Column32 | Column33 | Column342 | Column43 | Column5 | Column6 | Column3422 | Column433
SAMPLE 1 | 2 | 2+ |  |  |  |  |  |  |  |  |  |  |  | SAMPLE 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | SAMPLE 1 | 200 | 1000 | 2+
SAMPLE 2 | 3 |  | 3,8+ | 3.5 |  |  |  |  |  |  |  |  |  | SAMPLE 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | SAMPLE 2 | 100 | 33.33 |  | 3,8+ |  |  |  |  | 29.17 | 87.5
SAMPLE 3 | 14 |  | 14,1+ | 635 |  |  |  |  |  |  |  |  |  | SAMPLE 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | SAMPLE 3 | 140 | 280 |  | 14,1+ |  |  |  |  | 2760.87 | 63500
SAMPLE 4 | 2 |  |  | 3.6 | 6,9+ |  | 25 | 25.6 |  |  |  |  |  | SAMPLE 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | SAMPLE 4 | 40 | 86.96 |  |  | 1000 |  | 25.6 |  | 300 | 37.5 | 6,9+
SAMPLE 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | SAMPLE 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | SAMPLE 5
SAMPLE 6 |  |  |  |  |  |  |  |  |  |  |  |  |  | SAMPLE 6 |  |  |  |  |  |  |  |  |  |  |  |  |  | SAMPLE 6
SAMPLE 7 | 6 |  | ? |  |  |  |  |  |  |  |  |  |  | SAMPLE 7 |  |  |  |  |  |  |  |  |  |  |  |  |  | SAMPLE 7 |  |  |  | ?
SAMPLE 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | SAMPLE 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | SAMPLE 8
SAMPLE 9 | 6 |  |  |  |  |  |  |  |  |  |  |  |  | SAMPLE 9 |  |  |  |  |  |  |  |  |  |  |  |  |  | SAMPLE 9 | 40 | 75
SAMPLE 10 |  |  |  | 2 | 3+ |  | 6 |  |  |  |  |  |  | SAMPLE 10 |  |  |  |  |  |  |  |  |  |  |  |  |  | SAMPLE 10 |  |  |  |  | 400 | 750 |  |  | 100 | 40 | 3+
SAMPLE 11 |  |  |  |  |  |  |  |  |  |  |  |  |  | SAMPLE 11 |  |  |  |  |  |  |  |  |  |  |  |  |  | SAMPLE 11
SAMPLE 12 | 7 |  | ? |  |  |  |  |  |  |  |  |  |  | SAMPLE 12 |  |  |  |  |  |  |  |  |  |  |  |  |  | SAMPLE 12 | 38.89 | 73.68 |  | ?
SAMPLE 13 |  |  |  |  |  |  |  |  |  |  |  |  |  | SAMPLE 13 |  |  |  |  |  |  |  |  |  |  |  |  |  | SAMPLE 13
SAMPLE 14 |  |  |  |  |  |  |  |  |  |  |  |  |  | SAMPLE 14 |  |  |  |  |  |  |  |  |  |  |  |  |  | SAMPLE 14
SAMPLE 15 |  |  |  |  |  |  |  |  |  |  |  |  |  | SAMPLE 15 |  |  |  |  |  |  |  |  |  |  |  |  |  | SAMPLE 15 | 60 | 214.29
SAMPLE 16 |  |  |  | 25 |  |  | 8 | 9+ |  |  |  |  |  | SAMPLE 16 |  |  |  |  |  |  |  |  |  |  |  |  |  | SAMPLE 16 |  |  |  |  |  |  |  |  | 625 | 416.67
SAMPLE 17 |  |  |  | 35 |  | 82+ | 13 | 13+ |  |  |  |  |  | SAMPLE 17 |  |  |  |  |  |  |  |  |  |  |  |  |  | SAMPLE 17 |  |  |  |  | 1300 | 2600 | 13+ |  |  |  |  | 82+
SAMPLE 18 |  |  |  |  |  |  |  |  |  |  |  |  |  | SAMPLE 18 |  |  |  |  |  |  |  |  |  |  |  |  |  | SAMPLE 18
SAMPLE 19 |  |  |  |  |  |  |  |  |  |  |  |  |  | SAMPLE 19 |  |  |  |  |  |  |  |  |  |  |  |  |  | SAMPLE 19
SAMPLE 20 |  |  |  |  |  |  |  |  |  |  |  |  |  | SAMPLE 20 |  |  |  |  |  |  |  |  |  |  |  |  |  | SAMPLE 20
SAMPLE 21 |  |  |  |  |  |  |  |  |  |  |  |  |  | SAMPLE 21 |  |  |  |  |  |  |  |  |  |  |  |  |  | SAMPLE 21
SAMPLE 22 | 2 |  |  | 3 |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 150
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 700
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13.33333333333333
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 75
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 120
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70