|
|
Verweis mit mehreren Kriterien | VERWEIS | | | | | | | | | | | | | | A | B | C | D | E | | | | | | | | | Kriterium 1 | Kriterium 2 | Daten | | Eingabefelder | | | 100 | 150 | wert 001 | | 101 | Suchwert zu Kriterium 1 | | 101 | 151 | wert 002 | | 151 | Suchwert zu Kriterium 2 | | 102 | 152 | wert 003 | | | | | 103 | 153 | wert 004 | | | | | 104 | 154 | wert 005 | | | | | 105 | 155 | wert 006 | | | | | 106 | 156 | wert 007 | | | | | 107 | 157 | wert 008 | | | | | 108 | 158 | wert 009 | | Ergebnis: | Formel: | | 109 | 159 | wert 010 | | wert 002 | =VERWEIS(2;1/(A2:A11&B2:B11=E2&E3);C2:C11) | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
|
zurück