PDA

Vollständige Version anzeigen : Werte aus Tabelle über SVERWEIS


olerostock
14.07.2014, 12:44
Hallo an die Gemeinde!

Ich komme mit dem SVERWEIS nicht klar. Ich möchte in der Tabelle "Raumübersicht" in Spalte "F" den Wert der Anlage 1 eintragen lassen, wenn zwei Bedingungen erfüllt sind. 1.Die Raumnummer von Tabelle "Raumübersicht" Spalte A ab Zelle A3 muß mit der Raumnummer aus Tabelle "Anlagen" Spalte A ab Zelle A2 übereinstimmen und die Anlagennummer aus der Tabelle "Raumübersicht" Zeile 2 ab Zelle F2 muß mit der Anlagennummer aus der Tabelle "Anlagen" Spalte A übereinstimmen. Dann soll der jeweilige Wert für diese Anlage aus der Spalte J bei Zuluft und K bei Abluft in die Tabelle Raumübersicht eingetragen werden. Ist glaub ich ein bischen kompliziert erklärt. Die Tabelle habe ich mit hochgeladen. Die Bereiche die Übereinstimmen müßen sind grau gefärb und die Spalte aus denen die Werte kommen sollen sind grün gefärbt. Wer kann mir hierbei bitte helfen?

Danke für die Geduld und Hilfe.

Olerostock

Frank Furter
14.07.2014, 14:40
hallo, das geht auch nicht mit SVERWEIS()

scahu mal, ob dich das weiter bringt..:

http://www.excelformeln.de/formeln.html?welcher=30

olerostock
14.07.2014, 14:58
Hallo Frank Furter,

das hilft mir leider nicht weiter.

Danke trotzdem

Frank Furter
14.07.2014, 15:04
Hallo Frank Furter,

das hilft mir leider nicht weiter.

Danke trotzdem

ich hatte das so verstanden..:

<table border='1' cellspacing='0' cellpadding='2' valign='middle' colspan='11' style='font-family:Arial; color:#000000; background-color:#FFFFFF; font-size:11px; font-weight:normal; font-style:normal; '><colgroup><col width='28pt'><col width='67,5pt'><col width='60pt'><col width='87,75pt'><col width='71,25pt'><col width='60pt'><col width='60pt'><col width='60pt'><col width='60pt'><col width='60pt'><col width='60pt'></colgroup><tr style='background-color:#FAFAFA'><td align='middle' colspan='11'>Arbeitsblatt mit dem Namen 'Raumübersicht'</td></tr><tr style='background-color:#cacaca'><td>*</td><td align='middle'>A</td><td align='middle'>B</td><td align='middle'>C</td><td align='middle'>D</td><td align='middle'>E</td><td align='middle'>F</td><td align='middle'>G</td><td align='middle'>H</td><td align='middle'>I</td><td align='middle'>J</td></tr><tr><td style='background-color:#cacaca' align='middle'>2</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >Raumnummer</td><td align='left' style='font-size:10px; ' >Raumname</td><td align='left' style='font-size:10px; ' >Zonen-bezeichnung</td><td align='left' style='font-size:10px; ' >in m2</td><td align='left' style='font-size:10px; ' >in m</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >1</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >2</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >3</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >4</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >5</td></tr><tr><td style='background-color:#cacaca' align='middle'>3</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >BU.04A</td><td align='left' style='font-size:10px; ' >Vorraum</td><td align='left' style='font-size:10px; ' >16a</td><td align='right' style='font-size:10px; ' >11,8466</td><td align='right' style='font-size:10px; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td><td align='right' style='font-family:Calibri; ' >190</td><td align='left' style='font-family:Calibri; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td></tr><tr><td style='background-color:#cacaca' align='middle'>4</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >BU.01F</td><td align='left' style='font-size:10px; ' >Umkleide</td><td align='left' style='font-size:10px; ' >16a</td><td align='right' style='font-size:10px; ' >17,72</td><td align='right' style='font-size:10px; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td><td align='right' style='font-family:Calibri; ' >150</td><td align='left' style='font-family:Calibri; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td></tr><tr><td style='background-color:#cacaca' align='middle'>5</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >BU.04C</td><td align='left' style='font-size:10px; ' >WC D</td><td align='left' style='font-size:10px; ' >16a</td><td align='right' style='font-size:10px; ' >11,8466</td><td align='right' style='font-size:10px; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td><td align='right' style='font-family:Calibri; ' >0</td><td align='left' style='font-family:Calibri; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td></tr><tr><td style='background-color:#cacaca' align='middle'>6</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >BU.04B</td><td align='left' style='font-size:10px; ' >WC H</td><td align='left' style='font-size:10px; ' >16a</td><td align='right' style='font-size:10px; ' >11,8466</td><td align='right' style='font-size:10px; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td><td align='right' style='font-family:Calibri; ' >0</td><td align='left' style='font-family:Calibri; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td></tr><tr><td style='background-color:#cacaca' align='middle'>7</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >B0.11C</td><td align='left' style='font-size:10px; ' >WC D</td><td align='left' style='font-size:10px; ' >16a</td><td align='right' style='font-size:10px; ' >12,65</td><td align='right' style='font-size:10px; ' >*</td><td align='right' style='font-family:Calibri; ' >120</td><td align='left' style='font-family:Calibri; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td></tr><tr><td style='background-color:#cacaca' align='middle'>8</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >B0.11B</td><td align='left' style='font-size:10px; ' >WC H</td><td align='left' style='font-size:10px; ' >16a</td><td align='right' style='font-size:10px; ' >12,65</td><td align='right' style='font-size:10px; ' >*</td><td align='right' style='font-family:Calibri; ' >120</td><td align='left' style='font-family:Calibri; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td></tr><tr><td style='background-color:#cacaca' align='middle'>9</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >B0.11A</td><td align='left' style='font-size:10px; ' >Vorraum</td><td align='left' style='font-size:10px; ' >16a</td><td align='right' style='font-size:10px; ' >12,65</td><td align='right' style='font-size:10px; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td></tr><tr><td style='background-color:#cacaca' align='middle'>10</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >B1.16</td><td align='left' style='font-size:10px; ' >Vorb.</td><td align='left' style='font-size:10px; ' >16a</td><td align='right' style='font-size:10px; ' >13,39</td><td align='right' style='font-size:10px; ' >*</td><td align='right' style='font-family:Calibri; ' >60</td><td align='left' style='font-family:Calibri; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td><td align='right' style='font-family:Calibri; ' >200</td><td align='left' style='font-family:Calibri; ' >*</td></tr><tr><td style='background-color:#cacaca' align='middle'>11</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >B1.17</td><td align='left' style='font-size:10px; ' >WC Beh.</td><td align='left' style='font-size:10px; ' >16a</td><td align='right' style='font-size:10px; ' >9,71</td><td align='right' style='font-size:10px; ' >*</td><td align='right' style='font-family:Calibri; ' >100</td><td align='left' style='font-family:Calibri; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td><td align='right' style='font-family:Calibri; ' >180</td><td align='left' style='font-family:Calibri; ' >*</td></tr><tr><td style='background-color:#cacaca' align='middle'>12</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >B1.23</td><td align='left' style='font-size:10px; ' >WC D</td><td align='left' style='font-size:10px; ' >16a</td><td align='right' style='font-size:10px; ' >15,05</td><td align='right' style='font-size:10px; ' >*</td><td align='right' style='font-family:Calibri; ' >180</td><td align='left' style='font-family:Calibri; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td></tr><tr><td style='background-color:#cacaca' align='middle'>13</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >B1.24</td><td align='left' style='font-size:10px; ' >WC H</td><td align='left' style='font-size:10px; ' >16a</td><td align='right' style='font-size:10px; ' >15,05</td><td align='right' style='font-size:10px; ' >*</td><td align='right' style='font-family:Calibri; ' >210</td><td align='left' style='font-family:Calibri; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td></tr><tr><td style='background-color:#cacaca' align='middle'>14</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >B2.23</td><td align='left' style='font-size:10px; ' >WC D</td><td align='left' style='font-size:10px; ' >16a</td><td align='right' style='font-size:10px; ' >15,05</td><td align='right' style='font-size:10px; ' >*</td><td align='right' style='font-family:Calibri; ' >180</td><td align='left' style='font-family:Calibri; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td></tr><tr><td style='background-color:#cacaca' align='middle'>15</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >B2.24</td><td align='left' style='font-size:10px; ' >WC H</td><td align='left' style='font-size:10px; ' >16a</td><td align='right' style='font-size:10px; ' >15,05</td><td align='right' style='font-size:10px; ' >*</td><td align='right' style='font-family:Calibri; ' >210</td><td align='left' style='font-family:Calibri; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td></tr><tr><td style='background-color:#cacaca' align='middle'>16</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >B3.13</td><td align='left' style='font-size:10px; ' >WC D</td><td align='left' style='font-size:10px; ' >16a</td><td align='right' style='font-size:10px; ' >15,05</td><td align='right' style='font-size:10px; ' >*</td><td align='right' style='font-family:Calibri; ' >180</td><td align='left' style='font-family:Calibri; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td></tr><tr><td style='background-color:#cacaca' align='middle'>17</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >B3.14</td><td align='left' style='font-size:10px; ' >WC H</td><td align='left' style='font-size:10px; ' >16a</td><td align='right' style='font-size:10px; ' >15,05</td><td align='right' style='font-size:10px; ' >*</td><td align='right' style='font-family:Calibri; ' >210</td><td align='left' style='font-family:Calibri; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td><td align='left' style='font-family:Calibri; ' >*</td></tr></table><br><table border='3' cellspacing='0' cellpadding='2' valign='middle' colspan='2' style='table-layout:auto; color:#000000; background-color:#FFFFFF; font-family:Arial; font-size:10px;'><colgroup><col width='40pt'><col></colgroup><tr style='background-color:#eeaaaa'><td>Zelle</td><td>Formel</td></tr><tr><td>F3</td><td><Span style='color:#222222'>=WENNFEHLER</Span><Span style='color:#0000DD'>(VERWEIS</Span><Span style='color:#222222'>(2;1/</Span><Span style='color:#0000DD'>(Anlagen!$A$1:$A$400&" "&Anlagen!$E$1:$E$400=F$2&" "&$A3)</Span><Span style='color:#222222'>;Anlagen!$J$1:$J$400)</Span><Span style='color:#0000DD'>;"")</Span><Span style='color:#222222'></Span></td></tr></table><table style='font-family:Arial; font-size:7pt'><tr><td style='color:#333333'>Diese Tabelle wurde mit Tab2Html (v2.4.1) erstellt. ©Gerd alias Bamberg</td></tr></table>

Frank Furter
14.07.2014, 15:11
..:

<table border='1' cellspacing='0' cellpadding='2' valign='middle' colspan='11' style='font-family:Arial; color:#000000; background-color:#FFFFFF; font-size:11px; font-weight:normal; font-style:normal; '><colgroup><col width='28pt'><col width='67,5pt'><col width='60pt'><col width='87,75pt'><col width='71,25pt'><col width='60pt'><col width='60pt'><col width='60pt'><col width='60pt'><col width='60pt'><col width='60pt'></colgroup><tr style='background-color:#FAFAFA'><td align='middle' colspan='11'>Arbeitsblatt mit dem Namen 'Raumübersicht (2)'</td></tr><tr style='background-color:#cacaca'><td>*</td><td align='middle'>A</td><td align='middle'>B</td><td align='middle'>C</td><td align='middle'>D</td><td align='middle'>E</td><td align='middle'>F</td><td align='middle'>G</td><td align='middle'>H</td><td align='middle'>I</td><td align='middle'>J</td></tr><tr><td style='background-color:#cacaca' align='middle'>1</td><td align='left' style='font-size:10px; ' >WC und Sanitärräume in NWG Raumnummer</td><td align='left' style='font-size:10px; ' >Raumname</td><td align='right' style='font-size:10px; ' >*</td><td align='left' style='font-size:10px; ' >Nutzungsfläche</td><td align='left' style='font-size:10px; ' >Höhe</td><td colspan='5' rowspan='1' align='middle' style='font-size:10px; ' >Anlage - Zuluft</td></tr><tr><td style='background-color:#cacaca' align='middle'>2</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >Raumnummer</td><td align='left' style='font-size:10px; ' >Raumname</td><td align='left' style='font-size:10px; ' >Zonen-bezeichnung</td><td align='left' style='font-size:10px; ' >in m2</td><td align='left' style='font-size:10px; ' >in m</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >1</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >2</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >3</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >4</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >5</td></tr><tr><td style='background-color:#cacaca' align='middle'>3</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >BU.04A</td><td align='left' style='font-size:10px; ' >Vorraum</td><td align='left' style='font-size:10px; ' >16a</td><td align='right' style='font-size:10px; ' >11,8466</td><td align='right' style='font-size:10px; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >190</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td></tr><tr><td style='background-color:#cacaca' align='middle'>4</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >BU.01F</td><td align='left' style='font-size:10px; ' >Umkleide</td><td align='left' style='font-size:10px; ' >16a</td><td align='right' style='font-size:10px; ' >17,72</td><td align='right' style='font-size:10px; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >150</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td></tr><tr><td style='background-color:#cacaca' align='middle'>5</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >BU.04C</td><td align='left' style='font-size:10px; ' >WC D</td><td align='left' style='font-size:10px; ' >16a</td><td align='right' style='font-size:10px; ' >11,8466</td><td align='right' style='font-size:10px; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td></tr><tr><td style='background-color:#cacaca' align='middle'>6</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >BU.04B</td><td align='left' style='font-size:10px; ' >WC H</td><td align='left' style='font-size:10px; ' >16a</td><td align='right' style='font-size:10px; ' >11,8466</td><td align='right' style='font-size:10px; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td></tr><tr><td style='background-color:#cacaca' align='middle'>7</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >B0.11C</td><td align='left' style='font-size:10px; ' >WC D</td><td align='left' style='font-size:10px; ' >16a</td><td align='right' style='font-size:10px; ' >12,65</td><td align='right' style='font-size:10px; ' >*</td><td align='middle' style='font-family:Calibri; ' >120</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td></tr><tr><td style='background-color:#cacaca' align='middle'>8</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >B0.11B</td><td align='left' style='font-size:10px; ' >WC H</td><td align='left' style='font-size:10px; ' >16a</td><td align='right' style='font-size:10px; ' >12,65</td><td align='right' style='font-size:10px; ' >*</td><td align='middle' style='font-family:Calibri; ' >120</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td></tr><tr><td style='background-color:#cacaca' align='middle'>9</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >B0.11A</td><td align='left' style='font-size:10px; ' >Vorraum</td><td align='left' style='font-size:10px; ' >16a</td><td align='right' style='font-size:10px; ' >12,65</td><td align='right' style='font-size:10px; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td></tr><tr><td style='background-color:#cacaca' align='middle'>10</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >B1.16</td><td align='left' style='font-size:10px; ' >Vorb.</td><td align='left' style='font-size:10px; ' >16a</td><td align='right' style='font-size:10px; ' >13,39</td><td align='right' style='font-size:10px; ' >*</td><td align='middle' style='font-family:Calibri; ' >60</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >200</td><td align='middle' style='font-family:Calibri; ' >*</td></tr><tr><td style='background-color:#cacaca' align='middle'>11</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >B1.17</td><td align='left' style='font-size:10px; ' >WC Beh.</td><td align='left' style='font-size:10px; ' >16a</td><td align='right' style='font-size:10px; ' >9,71</td><td align='right' style='font-size:10px; ' >*</td><td align='middle' style='font-family:Calibri; ' >100</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >180</td><td align='middle' style='font-family:Calibri; ' >*</td></tr><tr><td style='background-color:#cacaca' align='middle'>12</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >B1.23</td><td align='left' style='font-size:10px; ' >WC D</td><td align='left' style='font-size:10px; ' >16a</td><td align='right' style='font-size:10px; ' >15,05</td><td align='right' style='font-size:10px; ' >*</td><td align='middle' style='font-family:Calibri; ' >180</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td></tr><tr><td style='background-color:#cacaca' align='middle'>13</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >B1.24</td><td align='left' style='font-size:10px; ' >WC H</td><td align='left' style='font-size:10px; ' >16a</td><td align='right' style='font-size:10px; ' >15,05</td><td align='right' style='font-size:10px; ' >*</td><td align='middle' style='font-family:Calibri; ' >210</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td></tr><tr><td style='background-color:#cacaca' align='middle'>14</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >B2.23</td><td align='left' style='font-size:10px; ' >WC D</td><td align='left' style='font-size:10px; ' >16a</td><td align='right' style='font-size:10px; ' >15,05</td><td align='right' style='font-size:10px; ' >*</td><td align='middle' style='font-family:Calibri; ' >180</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td></tr><tr><td style='background-color:#cacaca' align='middle'>15</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >B2.24</td><td align='left' style='font-size:10px; ' >WC H</td><td align='left' style='font-size:10px; ' >16a</td><td align='right' style='font-size:10px; ' >15,05</td><td align='right' style='font-size:10px; ' >*</td><td align='middle' style='font-family:Calibri; ' >210</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td></tr><tr><td style='background-color:#cacaca' align='middle'>16</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >B3.13</td><td align='left' style='font-size:10px; ' >WC D</td><td align='left' style='font-size:10px; ' >16a</td><td align='right' style='font-size:10px; ' >15,05</td><td align='right' style='font-size:10px; ' >*</td><td align='middle' style='font-family:Calibri; ' >180</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td></tr><tr><td style='background-color:#cacaca' align='middle'>17</td><td align='left' style='background-color:#D8D8D8; font-size:10px; ' >B3.14</td><td align='left' style='font-size:10px; ' >WC H</td><td align='left' style='font-size:10px; ' >16a</td><td align='right' style='font-size:10px; ' >15,05</td><td align='right' style='font-size:10px; ' >*</td><td align='middle' style='font-family:Calibri; ' >210</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td><td align='middle' style='font-family:Calibri; ' >*</td></tr></table><br><table border='3' cellspacing='0' cellpadding='2' valign='middle' colspan='3' style='color:#000000; background-color:#FFFFFF; font-family:Arial; font-size:10px;'><tr style='background-color:#aaeeaa'><td>Zelle</td><td>Format</td><td align='right'>Wert</td></tr><tr><td>F3</td><td>Standard;;</td><td align='right'>0</td></tr></table><br><table border='3' cellspacing='0' cellpadding='2' valign='middle' colspan='2' style='table-layout:auto; color:#000000; background-color:#FFFFFF; font-family:Arial; font-size:10px;'><colgroup><col width='40pt'><col></colgroup><tr style='background-color:#eeaaaa'><td>Zelle</td><td>Formel</td></tr><tr><td>F3</td><td><Span style='color:#222222'>=SUMMENPRODUKT</Span><Span style='color:#0000DD'>(</Span><Span style='color:#222222'>(Anlagen!$E$1:$E$400=$A3)</Span><Span style='color:#0000DD'>*</Span><Span style='color:#222222'>(Anlagen!$A$1:$A$400=F$2)</Span><Span style='color:#0000DD'>;Anlagen!$J$1:$J$400)</Span><Span style='color:#222222'></Span></td></tr></table><table style='font-family:Arial; font-size:7pt'><tr><td style='color:#333333'>Diese Tabelle wurde mit Tab2Html (v2.4.1) erstellt. ©Gerd alias Bamberg</td></tr></table>

olerostock
14.07.2014, 15:12
Hallo Frank Furter;

jetzt bin ich dahinter gestiegen. Funktioniert super. Danke Dir nochmal.

Gruß Olerostock