{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Quelle","Ziel (Formel)","Ziel (Makro Variante1)","Ziel (Makro Variante2)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Quelle","index":0,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["ID","Branchen_Art","Firma_Nr","Shopname","Anschrift","PLZ","Ort","Branche"]
["B010000001","B01","0000001","Bäckerei Hermann","Epiphanienweg 61","23999","Insel Poel","Bäckereien"]
["B010000003","B01","0000003","Bäckerei Mühle","Krausenstr. 40","23946","Ostseebad Boltenhagen","Bäckereien"]
["B010000004","B01","0000004","Bäckerei Lutz","Albert-Einstein-Str. 42","38707","Altenau","Bäckereien"]
["B010000005","B01","0000005","Bäckerei an der Allee","Allee der Kosmonauten 37","38707","Altenau","Bäckereien"]
["B010000006","B01","0000006","Bäckerei König","Alte Rhinstraße 1","39619","Arendsee","Bäckereien"]
["B010000007","B01","0000007","Bäckerei Meissner","Am Schwarzen Busch","83229","Aschau","Bäckereien"]
["B010000008","B01","0000008","Bäckerei Seeblick","Ostseeallee 190","25761","Büsum","Bäckereien"]
["B010000010","B01","0000010","Bäckerei Müller","Paretzer Straße 12","29549","Bad Bevensen","Bäckereien"]
["B020000001","B02","0000001","Apotheke Zack","An der Silberhütte 12","82433","Bad Kohlgrub","Apotheken"]
["B020000002","B02","0000002","Apotheke Dietrich","An der Silberhütte 12","82433","Bad Kohlgrub","Apotheken"]
["B020000003","B02","0000003","Apotheke Meyer","Lüchower Straße - Kurgebiet 1","82433","Bad Kohlgrub","Apotheken"]
["B020000004","B02","0000004","Apotheke Müller","Am Sonnenbichl 1","82433","Bad Kohlgrub","Apotheken"]
["B020000005","B02","0000005","Apotheke König","Königsberger Str. 12-16","82441","Ohlstadt","Apotheken"]
["B020000006","B02","0000006","Apotheke Lutz","Sebastian-Kneipp-Str. 5","82442","Saulgrub","Apotheken"]
["B020000007","B02","0000007","Apotheke Mühle","Kehrerstr. 23","82481","Mittenwald","Apotheken"]
["B020000008","B02","0000008","Apotheke König","Kehrerstr. 24 a","82487","Oberammergau","Apotheken"]
["B020000009","B02","0000009","Apotheke Hennesberg","Saulgruberstr.6","82487","Oberammergau","Apotheken"]
["B020000010","B02","0000010","Apotheke Seyfried","Fallerstr. 11","82541","Ambach (Starnberger See)","Apotheken"]
["B030000001","B03","0000001","Supermarkt Seidel","Boschetstr. 5","97980","Bad Mergentheim","Lebensmittel-Einzelhandel"]
["B030000002","B03","0000002","Bioladen Bauer","Alte Römerstr. 41-43","31812","Bad Pyrmont","Lebensmittel-Einzelhandel"]
["B030000003","B03","0000003","Supermarkt Mendel","Fischerweg 1-6","87459","Pfronten","Lebensmittel-Einzelhandel"]
["B030000004","B03","0000004","Getränkemarkt Huber","Hubertusstr. 2","72574","Bad Urach","Lebensmittel-Einzelhandel"]
["B030000005","B03","0000005","Supermarkt Maurer","Hubertusstraße 40","59505","Bad Sassendorf","Lebensmittel-Einzelhandel"]
["B030000006","B03","0000006","Supermarkt Heidelberger","Simetsbergweg 11","97688","Bad Kissingen","Lebensmittel-Einzelhandel"]
["B030000007","B03","0000007","Biomarkt Ludwig","Lothar-Daiker-Str. 17","25980","Sylt / OT Westerland","Lebensmittel-Einzelhandel"]
["B030000008","B03","0000008","Supermarkt Fey","Vogelreichsweg 49","08645","Bad Elster","Lebensmittel-Einzelhandel"]
["B040000001","B04","0000001","Drogerie Lutz","Peter-Heel-Str. 29","03046","Cottbus","Drogerien"]
["B040000002","B04","0000002","Drogerie Gerald","Bei den Thermen 12","07743","Jena","Drogerien"]
["B040000003","B04","0000003","Drogerie Tosidahl","Hepper Landstr. 2","10115","Berlin","Drogerien"]
["B040000004","B04","0000004","Drogerie König","Am Kurgarten 5","10407","Berlin","Drogerien"]
["B040000005","B04","0000005","Drogerie Mühle","Norderstr. 53","10713","Berlin","Drogerien"]
["B040000006","B04","0000006","Drogerie Nagel","Prof.-Paul-Köhler-Str. 3","14059","Berlin","Drogerien"]
["B040000007","B04","0000007","Drogerie Mühle","Feigestr. 1","10117","Berlin","Drogerien"]
["B040000008","B04","0000008","Drogerie Lutz","Michael-Häußler-Weg 12","12489","Berlin","Drogerien"]
["B040000009","B04","0000009","Drogerie Mühle","Gartenstr. 5","12681","Berlin","Drogerien"]
["B040000010","B04","0000010","Drogerie König","Landsberger Allee 117","12681","Berlin","Drogerien"]

{"sheet":"Ziel (Formel)","index":1,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,1],[17,5,19,10],[23,5,24,10]]}
["Formel:",null,"=SVERWEIS(A1;Quelle!A:D;4;FALSCH)","=SVERWEIS(B1;Quelle!C:D;2;FALSCH)"]
["ID","Firma_Nr","Shopname (Sverweis mit Spalte A)","Shopname (Sverweis mit Spalte B)"]
["B010000001","0000001",{"$f":"VLOOKUP(A3,Quelle!A:D,4,FALSE)","v":"Bäckerei Hermann"},{"$f":"VLOOKUP(B3,Quelle!C:D,2,FALSE)","v":"Bäckerei Hermann"}]
["B010000003","0000003",{"$f":"VLOOKUP(A4,Quelle!A:D,4,FALSE)","v":"Bäckerei Mühle"},{"$f":"VLOOKUP(B4,Quelle!C:D,2,FALSE)","v":"Bäckerei Mühle"}]
["B010000004","0000004",{"$f":"VLOOKUP(A5,Quelle!A:D,4,FALSE)","v":"Bäckerei Lutz"},{"$f":"VLOOKUP(B5,Quelle!C:D,2,FALSE)","v":"Bäckerei Lutz"},null,"Die klassische Sverweis-Funktion bietet nur eingeschränkte Möglichkeiten."]
["B010000005","0000005",{"$f":"VLOOKUP(A6,Quelle!A:D,4,FALSE)","v":"Bäckerei an der Allee"},{"$f":"VLOOKUP(B6,Quelle!C:D,2,FALSE)","v":"Bäckerei an der Allee"}]
["B020000001","0000001",{"$f":"VLOOKUP(A7,Quelle!A:D,4,FALSE)","v":"Apotheke Zack"},{"$f":"VLOOKUP(B7,Quelle!C:D,2,FALSE)","v":"Bäckerei Hermann"}]
["B020000002","0000002",{"$f":"VLOOKUP(A8,Quelle!A:D,4,FALSE)","v":"Apotheke Dietrich"},{"$f":"VLOOKUP(B8,Quelle!C:D,2,FALSE)","v":"Apotheke Dietrich"},null,"Vorteile:"]
["B020000003","0000003",{"$f":"VLOOKUP(A9,Quelle!A:D,4,FALSE)","v":"Apotheke Meyer"},{"$f":"VLOOKUP(B9,Quelle!C:D,2,FALSE)","v":"Bäckerei Mühle"},null,"+ bei Änderung der Datenquelle aktualisiert sich der Zellwert automatisch"]
["B020000004","0000004",{"$f":"VLOOKUP(A10,Quelle!A:D,4,FALSE)","v":"Apotheke Müller"},{"$f":"VLOOKUP(B10,Quelle!C:D,2,FALSE)","v":"Bäckerei Lutz"}]
["B020000005","0000005",{"$f":"VLOOKUP(A11,Quelle!A:D,4,FALSE)","v":"Apotheke König"},{"$f":"VLOOKUP(B11,Quelle!C:D,2,FALSE)","v":"Bäckerei an der Allee"}]
["B030000001","0000001",{"$f":"VLOOKUP(A12,Quelle!A:D,4,FALSE)","v":"Supermarkt Seidel"},{"$f":"VLOOKUP(B12,Quelle!C:D,2,FALSE)","v":"Bäckerei Hermann"}]
["B030000002","0000002",{"$f":"VLOOKUP(A13,Quelle!A:D,4,FALSE)","v":"Bioladen Bauer"},{"$f":"VLOOKUP(B13,Quelle!C:D,2,FALSE)","v":"Apotheke Dietrich"}]
["B030000003","0000003",{"$f":"VLOOKUP(A14,Quelle!A:D,4,FALSE)","v":"Supermarkt Mendel"},{"$f":"VLOOKUP(B14,Quelle!C:D,2,FALSE)","v":"Bäckerei Mühle"},null,"Nachteile:"]
["B030000004","0000004",{"$f":"VLOOKUP(A15,Quelle!A:D,4,FALSE)","v":"Getränkemarkt Huber"},{"$f":"VLOOKUP(B15,Quelle!C:D,2,FALSE)","v":"Bäckerei Lutz"},null,"- beim Filtern werden die Zellwerte neu berechnet"]
["B030000005","0000005",{"$f":"VLOOKUP(A16,Quelle!A:D,4,FALSE)","v":"Supermarkt Maurer"},{"$f":"VLOOKUP(B16,Quelle!C:D,2,FALSE)","v":"Bäckerei an der Allee"},null,"- gegenüber reinen Zellwerten erhöhter Speicherbedarf"]
["B040000001","0000001",{"$f":"VLOOKUP(A17,Quelle!A:D,4,FALSE)","v":"Drogerie Lutz"},{"$f":"VLOOKUP(B17,Quelle!C:D,2,FALSE)","v":"Bäckerei Hermann"},null,"- ist der Suchbegriff nicht vorhanden, wird #NV ausgegeben"]
["B040000002","0000002",{"$f":"VLOOKUP(A18,Quelle!A:D,4,FALSE)","v":"Drogerie Gerald"},{"$f":"VLOOKUP(B18,Quelle!C:D,2,FALSE)","v":"Apotheke Dietrich"},null,"- es wird immer der erste gefundene Treffer angezeigt, der Suchbegriff muss daher eindeutig sein! Siehe Fehler in Spalte D bei Verwendung der reinen Firmen-Nummer als Suchbegriff"]
["B040000003","0000003",{"$f":"VLOOKUP(A19,Quelle!A:D,4,FALSE)","v":"Drogerie Tosidahl"},{"$f":"VLOOKUP(B19,Quelle!C:D,2,FALSE)","v":"Bäckerei Mühle"}]
["B040000004","0000004",{"$f":"VLOOKUP(A20,Quelle!A:D,4,FALSE)","v":"Drogerie König"},{"$f":"VLOOKUP(B20,Quelle!C:D,2,FALSE)","v":"Bäckerei Lutz"}]
["B040000005","0000005",{"$f":"VLOOKUP(A21,Quelle!A:D,4,FALSE)","v":"Drogerie Mühle"},{"$f":"VLOOKUP(B21,Quelle!C:D,2,FALSE)","v":"Bäckerei an der Allee"},null,"- alle Zellen müssen im gleichen Datenformat formatiert sein"]
[]
[null,null,null,null,null,"Tipp:"]
[null,null,"richtig!","falsch!",null,"Über einen rechten Mausklick \"Inhalte einfügen\", können die Formeln nach der Berechnung durch Zellwerte ersetzt werden."]
[]
[]
[]
[]
[null,null,"=SVERWEIS(Suchkriterium;Matrix;Spaltenindex;Bereich-Verweis)"]
[]
[null,null,"Suchkriterium = Zelle der den Suchbegriff beinhaltet"]
[null,null,"Matrix = Spaltenbereich in dem gesucht werden soll (erste Spalte muss das Suchkriterium beinhalten)"]
[null,null,"Spaltenindex = Innerhalb der Matrix die Spalte von links"]
[null,null,"Bereich-Verweis = WAHR oder FALSCH -> FALSCH = genaue Übereinstimmung des Suchbegriffs (Standard)"]

{"sheet":"Ziel (Makro Variante1)","index":2,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Suchkriterium"]
["ID","Shopname","Anschrift","PLZ","Ort","Branche"]
["B010000001","Bäckerei Hermann","Epiphanienweg 61","23999","Insel Poel","Bäckereien"]
["B010000003","Bäckerei Mühle","Krausenstr. 40","23946","Ostseebad Boltenhagen","Bäckereien"]
["B010000004","Bäckerei Lutz","Albert-Einstein-Str. 42","38707","Altenau","Bäckereien",null,"Variante 1 nutzt im Makro die Sverweis-Formel und bietet exakt die gleichen Möglichkeiten zur Konfiguration."]
["B010000005","Bäckerei an der Allee","Allee der Kosmonauten 37","38707","Altenau","Bäckereien"]
["B020000001","Apotheke Zack","An der Silberhütte 12","82433","Bad Kohlgrub","Apotheken"]
["B020000002","Apotheke Dietrich","An der Silberhütte 12","82433","Bad Kohlgrub","Apotheken",null,"Vorteile:"]
["B020000003","Apotheke Meyer","Lüchower Straße - Kurgebiet 1","82433","Bad Kohlgrub","Apotheken",null,"+ es werden nur Werte in die Zellen geschrieben"]
["B020000004","Apotheke Müller","Am Sonnenbichl 1","82433","Bad Kohlgrub","Apotheken",null,"+ Makroverarbeitung schneller als Variante 2"]
["B020000005","Apotheke König","Königsberger Str. 12-16","82441","Ohlstadt","Apotheken"]
["B030000001","Supermarkt Seidel","Boschetstr. 5","97980","Bad Mergentheim","Lebensmittel-Einzelhandel"]
["B030000002","Bioladen Bauer","Alte Römerstr. 41-43","31812","Bad Pyrmont","Lebensmittel-Einzelhandel"]
["B030000003","Supermarkt Mendel","Fischerweg 1-6","87459","Pfronten","Lebensmittel-Einzelhandel",null,"Nachteile:"]
["B030000004","Getränkemarkt Huber","Hubertusstr. 2","72574","Bad Urach","Lebensmittel-Einzelhandel",null,"- bietet ausschließlich die gleichen Funktionen wie die Sverweis-Formelfunktion"]
["B030000005","Supermarkt Maurer","Hubertusstraße 40","59505","Bad Sassendorf","Lebensmittel-Einzelhandel",null,"- ist der Suchbegriff nicht vorhanden, bricht die Makroverarbeitung ab"]
["B040000001","Drogerie Lutz","Peter-Heel-Str. 29","03046","Cottbus","Drogerien",null,"- bei Änderung der Datenquelle aktualisiert sich der Zellwert nicht automatisch"]
["B040000002","Drogerie Gerald","Bei den Thermen 12","07743","Jena","Drogerien",null,"- es wird immer der erste gefundene Treffer angezeigt, der Suchbegriff muss daher eindeutig sein!"]
["B040000003","Drogerie Tosidahl","Hepper Landstr. 2","10115","Berlin","Drogerien"]
["B040000004","Drogerie König","Am Kurgarten 5","10407","Berlin","Drogerien"]
["B040000005","Drogerie Mühle","Norderstr. 53","10713","Berlin","Drogerien"]

{"sheet":"Ziel (Makro Variante2)","index":3,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[[3,8,5,16],[0,0,0,1]]}
["Suchkriterium"]
["Branchen_Art","Firma_Nr","Shopname","Anschrift","PLZ","Ort","Branche"]
["B01","0000001","Bäckerei Hermann","Epiphanienweg 61","23999","Insel Poel","Bäckereien"]
["B01","0000003","Bäckerei Mühle","Krausenstr. 40","23946","Ostseebad Boltenhagen","Bäckereien",null,"Variante 2 nutzt ein individuelles Makro, dass eine ähnliche Funktionsweise zur Sverweis-Funktion bietet. Die zu suchenden Werte können allerdings in beliebigem Verhältnis zum Suchbegriff stehen (links oder rechts davon, jeweils eine bestimmte Anzahl Zeilen darüber oder darunter etc.)"]
["B01","0000004","Bäckerei Lutz","Albert-Einstein-Str. 42","38707","Altenau","Bäckereien"]
["B01","0000005","Bäckerei an der Allee","Allee der Kosmonauten 37","38707","Altenau","Bäckereien"]
["B02","0000001","Apotheke Zack","An der Silberhütte 12","82433","Bad Kohlgrub","Apotheken"]
["B02","0000002","Apotheke Dietrich","An der Silberhütte 12","82433","Bad Kohlgrub","Apotheken",null,"Vorteile:"]
["B02","0000003","Apotheke Meyer","Lüchower Straße - Kurgebiet 1","82433","Bad Kohlgrub","Apotheken",null,"+ es werden nur Werte in die Zellen geschrieben"]
["B02","0000004","Apotheke Müller","Am Sonnenbichl 1","82433","Bad Kohlgrub","Apotheken",null,"+ Werte in unterschiedlicher Abhängigkeit können ermittelt werden"]
["B02","0000005","Apotheke König","Königsberger Str. 12-16","82441","Ohlstadt","Apotheken",null,"+ nicht gefundene Suchbegriffe werden als leerer Zellwert dargestellt oder können mit einem Dummy-Wert befüllt werden"]
["B03","0000001","Supermarkt Seidel","Boschetstr. 5","97980","Bad Mergentheim","Lebensmittel-Einzelhandel",null,"+ der Suchbegriff kann aus mehreren Spalten gebildet werden"]
["B03","0000002","Bioladen Bauer","Alte Römerstr. 41-43","31812","Bad Pyrmont","Lebensmittel-Einzelhandel"]
["B03","0000003","Supermarkt Mendel","Fischerweg 1-6","87459","Pfronten","Lebensmittel-Einzelhandel",null,"Nachteile:"]
["B03","0000004","Getränkemarkt Huber","Hubertusstr. 2","72574","Bad Urach","Lebensmittel-Einzelhandel",null,"- Makroverarbeitung langsamer als Variante 1"]
["B03","0000005","Supermarkt Maurer","Hubertusstraße 40","59505","Bad Sassendorf","Lebensmittel-Einzelhandel",null,"- bei Änderung der Datenquelle aktualisiert sich der Zellwert nicht automatisch"]
["B04","0000001","Drogerie Lutz","Peter-Heel-Str. 29","03046","Cottbus","Drogerien",null,"- es wird immer der erste gefundene Treffer angezeigt, der Suchbegriff muss daher eindeutig sein!"]
["B04","0000002","Drogerie Gerald","Bei den Thermen 12","07743","Jena","Drogerien"]
["B04","0000003","Drogerie Tosidahl","Hepper Landstr. 2","10115","Berlin","Drogerien"]
["B04","0000004","Drogerie König","Am Kurgarten 5","10407","Berlin","Drogerien"]
["B04","0000005","Drogerie Mühle","Norderstr. 53","10713","Berlin","Drogerien"]