Spreadsheet: 763355d1642123386-extracting-the-corresponding-value-for-the-first-instance-of-occurrence-map1
Sheet: Blad1

L-P-M1 |  |  |  | Functionele code | Positie | Yes/No
Via vlookup search for value in cell [NAME] in column E and return 1st matching value when value in column G is "yes" |  |  |  | LTF-601-01 | E-A-A-A-E | Yes
Via vlookup search for value in cell [NAME] in column E and return 2nd matching value when value in column G is "yes" |  |  |  | LTF-601-02 | E-A-A-A-E-A | Yes
Via vlookup search for value in cell [NAME] in column E and return 3rd matching value when value in column G is "yes" |  |  |  | T-600-02 | E-A-A-A-G-A-A | No
Via vlookup search for value in cell [NAME] in column E and return 4th matching value when value in column G is "yes" |  |  |  | LS-600-11 | E-A-A-A-G-A-B-A | Yes
 |  |  |  | T-600-01 | E-A-A-A-G-B-A | Yes
 |  |  |  | LS-600-01 | E-A-A-A-G-B-B-A | No
 |  |  |  | P-600-31 | E-A-A-B-A-A-A | Yes
 |  |  |  | P-600-31-M | E-A-A-B-A-A-B | Yes
 |  |  |  | PI-600-02 | E-A-A-B-A-A-D-A | No
 |  |  |  | PI-600-03 | E-A-A-B-A-A-D-B | Yes
 |  |  |  | TSH-600-01 | E-A-A-B-A-A-D-C | Yes
 |  |  |  | FSL-600-01 | E-A-A-B-A-A-D-D | No
 |  |  |  | [NAME] | E-A-A-B-A-A-D-E | Yes
 |  |  |  | HS-600-01 | E-A-A-B-A-A-D-F | Yes
 |  |  |  | [NAME] | E-A-A-B-A-B-AH-C-A | No
 |  |  |  | [NAME] | E-A-A-B-A-B-AH-C-B | Yes
 |  |  |  | [NAME] | E-A-A-B-A-B-AH-C-C | Yes
 |  |  |  | [NAME] | E-A-A-B-A-B-AH-C-D | No
 |  |  |  | [NAME] | E-A-A-B-A-B-AH-D | Yes
 |  |  |  | [NAME] | E-A-A-B-A-B-AH-D-A | Yes
 |  |  |  | L-P-M1 | E-A-A-B-A-B-AH-D-B | No
 |  |  |  | [NAME] | E-A-A-B-A-B-AH-D-C | Yes
 |  |  |  | [NAME] | E-A-A-B-A-B-AH-D-D | Yes
 |  |  |  | NRV-600-01 | E-A-A-B-A-B-AI-A | Yes
 |  |  |  | SPB-600-04 | E-A-A-B-A-B-AP-A | Yes
 |  |  |  | SPB-600-05 | E-A-A-B-A-B-AP-B | No
 |  |  |  | SPB-600-06 | E-A-A-B-A-B-AP-C | Yes
 |  |  |  | SPB-600-07 | E-A-A-B-A-B-AP-D | Yes
 |  |  |  | F-600-01 | E-A-A-B-A-B-B | No
 |  |  |  | P-600-01 | E-A-A-B-BA-A-A | Yes
 |  |  |  | P-600-01-M | E-A-A-B-BA-A-B | Yes
 |  |  |  | LS -600-02 | E-A-A-B-BA-D-A | No
 |  |  |  | IF-600-01 | E-A-A-B-BA-F | Yes
 |  |  |  | P-600-11 | E-A-A-B-CA-A-A | Yes
 |  |  |  | P-600-11-M | E-A-A-B-CA-A-B | No
 |  |  |  | LS -600-12 | E-A-A-B-CA-D-A | Yes
 |  |  |  | IF-600-11 | E-A-A-B-CA-F | Yes
 |  |  |  | P-550-01 | E-A-A-B-DA-A-A | Yes
 |  |  |  | P-550-01-M | E-A-A-B-DA-A-B | No
 |  |  |  | NRV-550-01 | E-A-A-B-DA-C-AI-A | Yes
 |  |  |  | PI-550-01 | E-A-A-B-DA-D-A | Yes
 |  |  |  | F-550-01 | E-A-A-B-DA-F | No
 |  |  |  | HU-600-11 | E-A-A-C-A-B | Yes
 |  |  |  | HU-600-10 | E-A-A-C-B-B | Yes
 |  |  |  | HU-600-51 | E-A-A-D-A-A-A | No
 |  |  |  | HU-600-01 | E-A-A-D-A-B-A | Yes
 |  |  |  | [NAME] | E-A-A-D-D | Yes
 |  |  |  | VPA-LA03 | E-A-A-D-D-A | No
 |  |  |  | MOV-600-01 | E-A-A-D-D-C-A | Yes
 |  |  |  | MOV-600-01 | E-A-A-D-D-C-A-A | Yes
 |  |  |  | MOV-600-01-M | E-A-A-D-D-C-A-B | No
 |  |  |  | L-P-M1 | E-A-A-D-D-C-A-C | Yes
 |  |  |  | MOV-600-01-JB | E-A-A-D-D-C-A-D | Yes
 |  |  |  | SPB-600-03 | E-A-A-D-D-C-B | No
 |  |  |  | INF-600-03 | E-A-A-D-D-D-G | Yes
 |  |  |  | L-P-M1 | E-A-A-D-E | Yes
 |  |  |  | [NAME] | E-A-A-D-E-A | No
 |  |  |  | MOV-600-048 | E-A-A-D-E-C-B | Yes
 |  |  |  | [NAME] | E-A-A-D-E-C-B-A | Yes
 |  |  |  | [NAME] | E-A-A-D-E-C-B-B | Yes
 |  |  |  | [NAME] | E-A-A-D-E-C-B-C | Yes
 |  |  |  | [NAME] | E-A-A-D-E-C-B-D | No
 |  |  |  | [NAME] | E-A-A-D-E-C-C | Yes
 |  |  |  | [NAME] | E-A-A-D-E-C-C-A | Yes
 |  |  |  | [NAME] | E-A-A-D-E-C-C-B | No
 |  |  |  | [NAME] | E-A-A-D-E-C-C-C | Yes
 |  |  |  | [NAME] | E-A-A-D-E-C-C-D | Yes
 |  |  |  | [NAME] | E-A-A-D-E-C-D | No
 |  |  |  | [NAME] | E-A-A-D-E-C-D-A | Yes
 |  |  |  | [NAME] | E-A-A-D-E-C-D-B | Yes
 |  |  |  | [NAME] | E-A-A-D-E-C-D-C | No
 |  |  |  | [NAME] | E-A-A-D-E-C-D-D | Yes
 |  |  |  | [NAME] | E-A-A-D-E-C-E-A | Yes
 |  |  |  | [NAME] | E-A-A-D-E-C-E-B | Yes
 |  |  |  | [NAME] | E-A-A-D-E-C-E-C | No
 |  |  |  | [NAME] | E-A-A-D-E-C-E-D | Yes
 |  |  |  | TRV-600-10 | E-A-A-D-E-C-F-A | Yes
 |  |  |  | HV-600-90 | E-A-A-D-E-C-F-B | No
 |  |  |  | HV-600-89 | E-A-A-D-E-C-F-C | Yes
 |  |  |  | PI-600-07 | E-A-A-D-E-D-A | Yes
 |  |  |  | LAL-600-01 | E-A-A-D-E-D-B | No
 |  |  |  | LS-600-04 | E-A-A-D-E-D-C | Yes
 |  |  |  | INF-600-04 | E-A-A-D-E-D-G | Yes
 |  |  |  | L-P-M1 | E-A-A-D-G | No
 |  |  |  | [NAME] | E-A-A-D-G-A | Yes
 |  |  |  | [NAME] | E-A-A-D-G-C-A-A | Yes
 |  |  |  | [NAME] | E-A-A-D-G-C-A-B | No
 |  |  |  | [NAME] | E-A-A-D-G-C-A-C | Yes
 |  |  |  | [NAME] | E-A-A-D-G-C-A-D | Yes
 |  |  |  | [NAME] | E-A-A-D-G-C-B-A | No
 |  |  |  | [NAME] | E-A-A-D-G-C-B-B | Yes
 |  |  |  | [NAME] | E-A-A-D-G-C-B-C | Yes
 |  |  |  | A-603-02 | E-A-A-D-G-C-D | No
 |  |  |  | A-603-01 | E-A-A-D-G-C-E | Yes
 |  |  |  | AOV-603-01 | E-A-A-D-G-C-G | Yes
 |  |  |  | AOV-603-01 | E-A-A-D-G-C-G-A | Yes
 |  |  |  | AOV-603-01-M | E-A-A-D-G-C-G-B | Yes
 |  |  |  | AOV-603-01-WS | E-A-A-D-G-C-G-C | No
 |  |  |  | AOV-603-01-JB | E-A-A-D-G-C-G-D | Yes
 |  |  |  | AOV-603-01-ZSOC | E-A-A-D-G-C-G-E | Yes
 |  |  |  | NRV-603-03 | E-A-A-D-G-C-H | No
 |  |  |  | [NAME] | E-A-A-D-G-C-I-A | Yes
 |  |  |  | [NAME] | E-A-A-D-G-C-I-B | Yes
 |  |  |  | [NAME]-WS | E-A-A-D-G-C-I-C | No
 |  |  |  | [NAME] | E-A-A-D-G-C-I-D | Yes
 |  |  |  | MOV-601-01 | E-A-A-D-G-C-J-A | Yes
 |  |  |  | MOV-601-01-M | E-A-A-D-G-C-J-B | No
 |  |  |  | MOV-601-01-WS | E-A-A-D-G-C-J-C | Yes
 |  |  |  | TRV-601-01 | E-A-A-D-G-C-K-A | No
 |  |  |  | PI-601-61 | E-A-A-D-G-C-L | Yes
 |  |  |  | TT-603-01 | E-A-A-D-G-D-A | Yes
 |  |  |  | RO-603-01 | E-A-A-D-G-D-B | No