From users-de-return-7944-archive-asf-public=cust-asf.ponee.io@openoffice.apache.org Tue Aug 21 16:20:14 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id 6CE2D180630 for ; Tue, 21 Aug 2018 16:20:14 +0200 (CEST) Received: (qmail 48126 invoked by uid 500); 21 Aug 2018 14:20:13 -0000 Mailing-List: contact users-de-help@openoffice.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users-de@openoffice.apache.org Delivered-To: mailing list users-de@openoffice.apache.org Received: (qmail 48100 invoked by uid 99); 21 Aug 2018 14:20:12 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 21 Aug 2018 14:20:12 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 605821809CD for ; Tue, 21 Aug 2018 14:20:12 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -0.701 X-Spam-Level: X-Spam-Status: No, score=-0.701 tagged_above=-999 required=6.31 tests=[RCVD_IN_DNSWL_LOW=-0.7, SPF_PASS=-0.001] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id Q00roS53My3P for ; Tue, 21 Aug 2018 14:20:11 +0000 (UTC) Received: from mout.gmx.net (mout.gmx.net [212.227.15.19]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id CBE305F516 for ; Tue, 21 Aug 2018 14:20:10 +0000 (UTC) Received: from [192.168.100.108] ([88.72.173.51]) by mail.gmx.com (mrgmx003 [212.227.17.190]) with ESMTPSA (Nemesis) id 0Lxxrw-1fvdfy1tLA-015L7f for ; Tue, 21 Aug 2018 16:20:10 +0200 Subject: Re: [Calc] Schnittmenge zweier Tabellen To: users-de@openoffice.apache.org References: <2960731d-6f00-230a-a510-cb8f6873d453@boldt-webservice.de> From: Oliver Brinzing Message-ID: <133c8916-3eb2-f602-4bde-359aaaefd60e@gmx.de> Date: Tue, 21 Aug 2018 16:20:07 +0200 User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-Version: 1.0 In-Reply-To: <2960731d-6f00-230a-a510-cb8f6873d453@boldt-webservice.de> Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: de-DE Content-Transfer-Encoding: 8bit X-Provags-ID: V03:K1:nqWJdcwXPRHEuWm6NB2oMPqBZjxDOBhqX6iE0N6EF3bSaCoLFeJ +Wky4nCPW9o10LGKETcYCCRRxZzgOwSPMj1/urtN9nDEMo9hFYCFRSg/WlI2j36ymM07MHh D9fh1phU6dYsS20GQB8S9UfEariB5nd0OZ7PE0V/5qwA+4CiWZ8fOSfqRChIFRL7I2BwTb/ 94yLWCFnTmaNohxbAktkA== X-UI-Out-Filterresults: notjunk:1;V01:K0:dAnzm1AOTH4=:aEsm7k+gTcErGr7ty+9dM/ nXjEVl5SeanAdFilzj3II2Q5DmbwdRrd97OodtsfnCMiIw7YRVFQf4+Pph5Ll4Oqlmuz1wKVh 2DmKbVkd4KUYlNA6lY/lMCjItkBLfgiTYuvqd+9zRcfpIw0RUYb+/3QYnbD7h1xf1p6z+ijk0 FGX801E2G0TsymHDEzN1Vc4OB0Ow6yEiWuxSATSaYwG7SrmaVfiYNLfCXuvI2PRoClxQX17Ts S8MVFpVh9CzByRvOsTAy7MN8qcTfvB4xsHKwrgxi791rN5pG9lAJXV9AyRZ9UpxmJzH2UtmBS R5VzqTeAXY+RKeO2iXAcZYqBigTfWo+6yp3T5J3x3w5r5y0Zs8pWg+/6uZ+wT32nn/YA9tepW 1l7fr78AeozIa7672zLzH3pqEaT/auOBlWGd7LJE0q15pcwXvKMbGiWZ/e9adm18slkyALba2 HVgnF1sIVlKOPAEUXV01LVCfdwZy02jbc47nxlsp2ElUgJvF6vYoR9SLNd2q/MuNGBOuAxrPd ezr9kwSCAyyxHjF4QDiYFUBcRF6BdG6aEtIGl07An8MmxY+VWEY3RtdH2vUC97vcg9FU3gap1 fukE0XvogtwDG1p8nN+tJ10cm3UfN43NrI970SPanGb75wENW7uGPyRGEmzVP9d/dOGhIblNa UN04av/sV2BaJev1PHkOiA+aw8nLAi7q+x901b/4W33toe9ounMoHEKcRtIEbILFK5P3woImp rqQXBf5b5Pyr/yXmpnqojNqZD+er2YdOfPyK2nhTLXSwFeKoHElsFKWWQk3oPqU9il2JHi62u 7gx0M1T Hallo Romana, versuch mal folgendes: Tabelle1 A | B ---------------- 1 | E-Mail ID 2 | x 10 3 | y 11 4 | z 12 Tabelle2 A | B ---------------- 1 | E-Mail ID 2 | x =SVERWEIS(A2;$Tabelle1.$A$2:$B$6500;1;0) -> 10 3 | y =SVERWEIS(A3;$Tabelle1.$A$2:$B$6500;1;0) -> 11 4 | a =SVERWEIS(A4;$Tabelle1.$A$2:$B$6500;1;0) -> #NV Gruß Oliver Am 21.08.2018 um 15:44 schrieb Romana Boldt, Boldt Webservice: > Hallo Listige, > > ich habe zwei Tabellen. Tabelle 1 enthält Mailadressen und eine ID (rund > 6500), Tabelle 2 nur Mailadressen (rund 2300). Ich will heraus finden, > ob die Mailadressen aus Tabelle 2 in Tabelle 1 enthalten sind und die ID > in Tabelle 2 eintragen, sofern vorhanden. Ich habe keinen blassen Dunst, > wie ich das lösen kann. Ich bin zwar nicht auf den Kopf gefallen, habe > in Calc aber nur Grundkenntnisse. Ich vermute, dass dafür SVERWEIS > verwendet werden kann, aber aus den Beschreibungen zu der Funktion werde > ich nicht schlau. > > Kann mir einer auf die Sprünge helfen? > > Liebe Grüße > > Romana > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-de-unsubscribe@openoffice.apache.org > For additional commands, e-mail: users-de-help@openoffice.apache.org > --------------------------------------------------------------------- To unsubscribe, e-mail: users-de-unsubscribe@openoffice.apache.org For additional commands, e-mail: users-de-help@openoffice.apache.org