From users-de-return-7945-archive-asf-public=cust-asf.ponee.io@openoffice.apache.org Tue Aug 21 16:24:58 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 785AE180630 for ; Tue, 21 Aug 2018 16:24:57 +0200 (CEST) Received: (qmail 58936 invoked by uid 500); 21 Aug 2018 14:24:56 -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 58925 invoked by uid 99); 21 Aug 2018 14:24:55 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 21 Aug 2018 14:24:55 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id 7A7D8C05F4 for ; Tue, 21 Aug 2018 14:24:55 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 0.099 X-Spam-Level: X-Spam-Status: No, score=0.099 tagged_above=-999 required=6.31 tests=[KAM_ASCII_DIVIDERS=0.8, RCVD_IN_DNSWL_LOW=-0.7, SPF_PASS=-0.001] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id DTnYBbovC1Y4 for ; Tue, 21 Aug 2018 14:24:54 +0000 (UTC) Received: from mout.gmx.net (mout.gmx.net [212.227.15.15]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 10B855F396 for ; Tue, 21 Aug 2018 14:24:53 +0000 (UTC) Received: from [192.168.100.108] ([88.72.173.51]) by mail.gmx.com (mrgmx001 [212.227.17.190]) with ESMTPSA (Nemesis) id 0MRoyH-1fPqHn3Aoz-00SsLS for ; Tue, 21 Aug 2018 16:24:46 +0200 Subject: Re: [Calc] Schnittmenge zweier Tabellen To: users-de@openoffice.apache.org References: <2960731d-6f00-230a-a510-cb8f6873d453@boldt-webservice.de> <133c8916-3eb2-f602-4bde-359aaaefd60e@gmx.de> From: Oliver Brinzing Message-ID: <3db7bf00-e3fc-0729-2809-7ac57dc4d01e@gmx.de> Date: Tue, 21 Aug 2018 16:24:44 +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: <133c8916-3eb2-f602-4bde-359aaaefd60e@gmx.de> Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: de-DE Content-Transfer-Encoding: 8bit X-Provags-ID: V03:K1:fMaLQGdOkU1E8ZOInftjRa2F9BQCNQ828i2hpYMixfLAK7Vxipg gKELdH/MH0g20Moo2+g9E7+Bp1ZjXGtZdmZtUBo9uFAeDus0rVRICWjTenVvXVgtoLXph29 hsyoNdchjSOQgLSL0GhkFbTrfO9XK0gP4ppoKiLBzo8Vv7wWeE2aBbi0RFPWTQwq+Rbn3DB efa6JP/G6/rIxUNEjqWqA== X-UI-Out-Filterresults: notjunk:1;V01:K0:CnimgGRI1CE=:edcxroQaWIESMXZy0aYWnN lE5Dittd74Fcgd8EASvo2hPmCwioXGBMv6VmZG1w57Pm0gwMlpvBatEloYwkHo4JTtqPrkSmJ TX5grDJzSWtj+F9akGRiYcS2cfyoWRVdGKRCBPrXDcNVRPPeZW6U18QYmxkzCPfIfwqHIZxnd H1nAgWr990UQJ4Z6HClD70zpazfaxKop9DuilQ3oymWYLD4AihUYjBMs77+0b4m37LvFT1UKX xrdA0Beu5nA596GVyLPrpIsVhuL9wP9zyyPgqukuNIP8AYfL0K6dlMbvMmyOYnr6zh9jrk0M6 pn/rs74Sd6+VE7T76Rf7cDjN/Age/l8rQuoDGsB+D0Fju7USNPss32QitM15NW+r/+dO7VhRt 7wmC91n6XtWMLzXrJCuIqHOu0VVhC72crqapAjmf6434dzG8U1yQekcTDTggg7s0NHHlUkwtG x3/ouxMRD5D7yJI7jtPXOeKb4gYkFhKnXx+k+DrdTyhFjOtVWJDi7Lw/4pi2nJXGJdDVQM9qg UYQK34LTzasfqWa3oKwYyDxUlFUHlaTIQuzgJfnQaWDJkVQxVa+wV4TNAXxXG186HaTZVUbLW TvwdwR23k4MTnOQgLsVD4jSpnF/hH3GcgBN4yDnJG74y0m7U9TbDbaw21mS5OVf0/aRaC5MUl CHadShjo35PPzJLiKJqrv5IyCL9t5SQN0qDx2WEWCTpusbENTb8iF4WNQECWrW/TSZ4EVLV/4 w23OAleX6MtMg5pyJFgzhKQQvuYD2wNcJBSzrvpF/sgWQ1gzITvwKsUe1GMX8MbPYcPtReY9m kul1epe Kleine Korrektur;: Der 3. Parameter muss eine "2" sein, damit die 2. Spalte (ID) ausgegeben wird, also z.B. =SVERWEIS(A2;$Tabelle1.$A$2:$B$6500;2;0) > 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 > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-de-unsubscribe@openoffice.apache.org For additional commands, e-mail: users-de-help@openoffice.apache.org