Spreadsheet: 696207d1600702600-h-look-up-i-need-horizontal-look-up-test-index
Sheet: Tab1

Kundennr. | [NAME] | Werk | ABS | Kunden- artikelnr. | Artikel Kunde | Verkaufs- artikel | Basis- preis | Berechn. Preis | Piece price | ME/Preis | [NAME] ab | Usage Key Desc | Vertrags status | Preisermittlung | Supply Start Date
10010270 | H001 | APEX | D01 | 15780260 | E8x LHT CA TRAGERCABRIO | 15780260 | 1608 | 1608 | 16.08 | 100pcs | 31.07.2020 | After Sales | [NAME] | Rahmenvertragspreisliste | 01.06.2019
10010270 | H001 | APEX | D01 | 15780460 | E8x RHT CA TRAGERCABRIO | 15780460 | 1608 | 1608 | 16.08 | 100pcs | 31.07.2020 | After Sales | [NAME] | Rahmenvertragspreisliste | 01.06.2019
10010270 | H001 | APEX | D01 | 60034391 | DAI RH VIRGIN FOND | 60034391 | 56 | 56 | 0.56 | 100pcs | 31.07.2020 | After Sales | [NAME] | Rahmenvertragspreisliste | 01.06.2019
10010270 | H001 | APEX | D01 | 60036501 | DAI LHG VIRGIN | 60036501 | 372 | 372 | 3.72 | 100pcs | 31.07.2020 | After Sales | [NAME] | Rahmenvertragspreisliste | 01.06.2019
10010270 | H001 | APEX | D01 | 60036701 | DAI RHG VIRGIN | 60036701 | 196 | 196 | 1.96 | 100pcs | 31.07.2020 | After Sales | [NAME] | Rahmenvertragspreisliste | 01.06.2019
10010270 | H001 | APEX | D01 | 15213801 | US-GEWINDEEINSATZ M5 | 15213801 | 19 | 19 | 0.19 | 100pcs | 31.07.2020 | After Sales | Vorläufig | Rahmenvertragspreisliste | 01.01.2020
10010270 | H001 | APEX | D01 | 15456213 | KAPPE SCHLIESSZYLINDER E1 | 15456213 | 13 | 13 | 0.13 | 100pcs | 31.07.2020 | After Sales | Vorläufig | Rahmenvertragspreisliste | 01.01.2020
10010270 | H001 | APEX | D01 | 15456313 | KAPPE E1 | 15456313 | 14 | 14 | 0.14 | 100pcs | 31.07.2020 | After Sales | Vorläufig | Rahmenvertragspreisliste | 01.01.2020
10010270 | H001 | APEX | D01 | 15585260 | UNT.ELEKTRONIKTR. [NAME] | 15585260 | 1608 | 1608 | 16.08 | 100pcs | 31.07.2020 | After Sales | Vorläufig | Rahmenvertragspreisliste | 01.01.2020
10010270 | H001 | APEX | D01 | 15585460 | UNT.ELEKTRONIKTR. CA RE | 15585460 | 1608 | 1608 | 16.08 | 100pcs | 31.07.2020 | After Sales | Vorläufig | Rahmenvertragspreisliste | 01.01.2020
10010270 | H001 | APEX | D01 | 60034381 | [NAME] FOND | 60034381 | 44 | 44 | 0.44 | 100pcs | 31.07.2020 | After Sales | Vorläufig | Rahmenvertragspreisliste | 01.01.2020
 |  |  |  | 14255110 | 204 LHL KG VIRGIN
 |  |  |  | 14255310 | 204 [NAME]
 |  |  |  | 15211302 | DAI RH IR VIRGIN
 |  |  |  | 15211501 | DAI LHG LUX VIRGIN
 |  |  |  | 15211701 | DAI*RHG LUX
 |  |  |  | 15248203 | DAI LH [NAME]
 |  |  |  | 15300221 | DAI*LH  CAP
 |  |  |  | 15300851 | DAI RHC CR VIRGIN
 |  |  |  | 15444201 | VW GRP VT VIRGIN K'PER
 |  |  |  | 15444202 | VW GRP VT VIRGIN SCH'E |  |  |  | 2.82 | 100pcs | 27.02.2020
 |  |  |  | 15444203 | VW GRP VT VIRGIN D'KEL
 |  |  |  | 15444213 | VW [NAME]
 |  |  |  | 15444301 | VW GRP HT VIRGIN K'PER
 |  |  |  | 15444302 | VW GRP HT VIRGIN SCH'E
 |  |  |  | 15444303 | VW GRP HT VIRGIN D'KEL
 |  |  |  | 15444313 | VW CAP N/L VIRGIN
 |  |  |  | 15444501 | VW GRP STD VIRGIN
 |  |  |  | 15456202 | POR GRP VIRGIN |  |  |  | 0.6291 | 100pcs | 27.02.2020
 |  |  |  | 15456203 | POR KES STRIP VIRGIN
 |  |  |  | 15456502 | POR STD STRIP VIRGIN
 |  |  |  | 15490202 | INSERT BMW E60 Type |  |  |  | 0.0806 | 100pcs | 27.02.2020
 |  |  |  | 15523510 | DAI LHG 211 VT VIRGIN |  |  |  | 1.9477 | 100pcs | 27.02.2020
 |  |  |  | 15523710 | DAI RHG 211 VT VIRGIN |  |  |  | 1.3628 | 100pcs | 27.02.2020
 |  |  |  | 15524510 | DAI LHF 211 VT VIRGIN |  |  |  | 1.9778 | 100pcs | 27.02.2020
 |  |  |  | 15524710 | DAI RHF 211 VT VIRGIN
 |  |  |  | 15527510 | DAI LHG 220 VIRGIN |  |  |  | 3.38653 | 100pcs | 27.02.2020
 |  |  |  | 15527710 | DAI RHG 220 VIRGIN |  |  |  | 3.38653 | 100pcs | 27.02.2020
 |  |  |  | 15610510 | DAI LHF TAG VIRGIN
 |  |  |  | 15610710 | DAI RHF TAG [NAME]
 |  |  |  | 15627201 | DAI LHG 221 [NAME] |  |  |  | 1.4136 | 100pcs | 27.02.2020
 |  |  |  | 15627401 | DOOR HANDLE |  |  |  | 1.4077 | 100pcs | 27.02.2020
 |  |  |  | 15629410 | DAI RH 221 [NAME] |  |  |  | 1.48681 | 100pcs | 27.02.2020
 |  |  |  | 15630210 | DAI LH 221 [NAME] |  |  |  | 2.00688 | 100pcs | 27.02.2020
 |  |  |  | 15630610 | DAI*LH  221
 |  |  |  | 15694110 | 204 LHN [NAME]
 |  |  |  | 15694310 | 204*RHL KGI PRIMER GREY
 |  |  |  | 15732101 | [NAME] cyl left W204 |  |  |  | 0.17 | 100pcs | 27.02.2020
 |  |  |  | 15780260 | E8x LHT CA TRAGERCABRIO |  |  |  | 0.00113 | 100pcs | 27.02.2020
 |  |  |  | 15780460 | E8x RHT CA TRAGERCABRIO |  |  |  | 2.64711 | 100pcs | 27.02.2020
 |  |  |  | 60034391 | DAI RH VIRGIN FOND |  |  |  | 0.3448 | 100pcs | 27.02.2020
 |  |  |  | 60034802 | DAI GRP VIRGIN |  |  |  | 1.69 | 100pcs | 27.02.2020
 |  |  |  | 60036501 | DAI LHG VIRGIN |  |  |  | 2.9728 | 100pcs | 27.02.2020
 |  |  |  | 60036602 | DAI RHG VIRGIN |  |  |  | 2.9728 | 100pcs | 27.02.2020
 |  |  |  | 60036701 | DAI RHG VIRGIN |  |  |  | 1.5636 | 100pcs | 27.02.2020
 |  |  |  | 15343810 | DAI CAP 168 VIRGIN
 |  |  |  | 15695110 | 204 LHN KGO [NAME]
 |  |  |  | 15695310 | 204 RHN KGO VIRGIN