Spreadsheet: 861328d1709220149-vlookup-full-list-and-return-value-formula-fix-test-data-etaf
Sheet: Sheet6

Column A | Column B | Column C | Column D
[NAME] | Red | /nl-nl/article-skin-purification.html | Here should be "red"
article-beauty-outside.html | Blue | /nl-nl/article-beauty-outside.html | Here should be "Blue"
article-skincare-grooming-tips-for-him.html | Yellow | /nl-nl/article-skincare-grooming-tips-for-him.html | etc.
article-skincare-beauty-routines.html | White | /nl-nl/article-skincare-beauty-routines.html | etc.
article-skincare-sleep-problems.html | Green | /nl-nl/article-skincare-sleep-problems.html
article-skincare-5-tips-great-night-of-sleep.html | Purple | /nl-nl/article-skincare-5-tips-great-night-of-sleep.html
article-skincare-sleep-better-tips.html | orange | /nl-nl/article-skincare-sleep-better-tips.html
article-skincare-sleeping-routine.html | Grey | /nl-nl/article-skincare-sleeping-routine.html
article-skincare-what-sleep-does-for-your-body.html | Pink | /nl-nl/article-skincare-what-sleep-does-for-your-body.html
 |  | /en-hk/article-skin-purification.html | Here should be "red"
 |  | /en-hk/article-skincare-grooming-tips-for-him.html | Here should be "yellow"
 |  | /en-hk/article-skincare-sleeping-routine.html
 |  | /en-hk/article-skincare-what-sleep-does-for-your-body.html
 |  | /zh-hk/article-skin-purification.html
 |  | /zh-hk/article-beauty-outside.html
 |  | /zh-hk/article-skincare-grooming-tips-for-him.html
 |  | /zh-hk/article-skincare-beauty-routines.html
 |  | /zh-hk/article-skincare-sleep-problems.html
 |  | /zh-hk/article-skincare-5-tips-great-night-of-sleep.html
 |  | /zh-hk/article-skincare-sleep-better-tips.html
 |  | /zh-hk/article-skincare-sleeping-routine.html
 |  | /zh-hk/article-skincare-what-sleep-does-for-your-body.html
 |  | /no-no/article-skin-purification.html
 |  | /no-no/article-beauty-outside.html
 |  | /no-no/article-skincare-grooming-tips-for-him.html
 |  | /no-no/article-skincare-beauty-routines.html
 |  | /no-no/article-skincare-sleep-problems.html
 |  | /no-no/article-skincare-5-tips-great-night-of-sleep.html
 |  | /no-no/article-skincare-sleep-better-tips.html
 |  | /no-no/article-skincare-sleeping-routine.html
 |  | /no-no/article-skincare-what-sleep-does-for-your-body.html
 |  | /da-dk/article-skin-purification.html
 |  | /da-dk/article-beauty-outside.html
 |  | /da-dk/article-skincare-grooming-tips-for-him.html
 |  | /da-dk/article-skincare-beauty-routines.html
 |  | /da-dk/article-skincare-sleep-problems.html
 |  | /da-dk/article-skincare-5-tips-great-night-of-sleep.html
 |  | /da-dk/article-skincare-sleep-better-tips.html
 |  | /da-dk/article-skincare-sleeping-routine.html
 |  | /da-dk/article-skincare-what-sleep-does-for-your-body.html
 |  | /sv-se/article-skin-purification.html
 |  | /sv-se/article-beauty-outside.html
 |  | /sv-se/article-skincare-grooming-tips-for-him.html
 |  | /sv-se/article-skincare-beauty-routines.html
 |  | /sv-se/article-skincare-sleep-problems.html
 |  | /sv-se/article-skincare-5-tips-great-night-of-sleep.html
 |  | /sv-se/article-skincare-sleep-better-tips.html
 |  | /sv-se/article-skincare-sleeping-routine.html
 |  | /sv-se/article-skincare-what-sleep-does-for-your-body.html
 |  | /de-ch/article-skin-purification.html
 |  | /de-ch/article-beauty-outside.html
 |  | /de-ch/article-skincare-grooming-tips-for-him.html
 |  | /de-ch/article-skincare-beauty-routines.html
 |  | /de-ch/article-skincare-sleep-problems.html
 |  | /de-ch/article-skincare-5-tips-great-night-of-sleep.html
 |  | /de-ch/article-skincare-sleep-better-tips.html
 |  | /de-ch/article-skincare-sleeping-routine.html
 |  | /de-ch/article-skincare-what-sleep-does-for-your-body.html
 |  | /fr-ch/article-skin-purification.html
 |  | /fr-ch/article-beauty-outside.html
 |  | /fr-ch/article-skincare-grooming-tips-for-him.html
 |  | /fr-ch/article-skincare-beauty-routines.html
 |  | /fr-ch/article-skincare-sleep-problems.html
 |  | /fr-ch/article-skincare-5-tips-great-night-of-sleep.html
 |  | /fr-ch/article-skincare-sleep-better-tips.html
 |  | /fr-ch/article-skincare-sleeping-routine.html
 |  | /fr-ch/article-skincare-what-sleep-does-for-your-body.html
 |  | /en-nl/article-skin-purification.html
 |  | /en-nl/article-beauty-outside.html
 |  | /en-nl/article-skincare-grooming-tips-for-him.html
 |  | /en-nl/article-skincare-beauty-routines.html
 |  | /en-nl/article-skincare-sleep-problems.html
 |  | /en-nl/article-skincare-5-tips-great-night-of-sleep.html
 |  | /en-nl/article-skincare-sleep-better-tips.html
 |  | /en-nl/article-skincare-sleeping-routine.html
 |  | /en-nl/article-skincare-what-sleep-does-for-your-body.html
 |  | /fr-fr/article-skin-purification.html
 |  | /fr-fr/article-beauty-outside.html
 |  | /fr-fr/article-skincare-grooming-tips-for-him.html
 |  | /fr-fr/article-skincare-beauty-routines.html
 |  | /fr-fr/article-skincare-sleep-problems.html
 |  | /fr-fr/article-skincare-5-tips-great-night-of-sleep.html
 |  | /fr-fr/article-skincare-sleep-better-tips.html
 |  | /fr-fr/article-skincare-sleeping-routine.html
 |  | /fr-fr/article-skincare-what-sleep-does-for-your-body.html
 |  | [NAME]/article-skin-purification.html
 |  | [NAME]/article-beauty-outside.html
 |  | [NAME]/article-skincare-grooming-tips-for-him.html
 |  | [NAME]/article-skincare-beauty-routines.html
 |  | [NAME]/article-skincare-sleep-problems.html
 |  | [NAME]/article-skincare-5-tips-great-night-of-sleep.html
 |  | [NAME]/article-skincare-sleep-better-tips.html
 |  | [NAME]/article-skincare-sleeping-routine.html
 |  | [NAME]/article-skincare-what-sleep-does-for-your-body.html
 |  | /de-de/article-skin-purification.html
 |  | /de-de/article-beauty-outside.html
 |  | /de-de/article-skincare-grooming-tips-for-him.html
 |  | /de-de/article-skincare-beauty-routines.html
 |  | /de-de/article-skincare-sleep-problems.html
 |  | /de-de/article-skincare-5-tips-great-night-of-sleep.html
 |  | /de-de/article-skincare-sleep-better-tips.html
 |  | /de-de/article-skincare-sleeping-routine.html
 |  | /de-de/article-skincare-what-sleep-does-for-your-body.html
 |  | /ro-ro/article-skin-purification.html
 |  | /ro-ro/article-beauty-outside.html
 |  | /ro-ro/article-skincare-grooming-tips-for-him.html
 |  | /ro-ro/article-skincare-beauty-routines.html
 |  | /ro-ro/article-skincare-sleep-problems.html
 |  | /ro-ro/article-skincare-5-tips-great-night-of-sleep.html
 |  | /ro-ro/article-skincare-sleep-better-tips.html
 |  | /ro-ro/article-skincare-sleeping-routine.html
 |  | /ro-ro/article-skincare-what-sleep-does-for-your-body.html
 |  | /it-it/article-skin-purification.html
 |  | /it-it/article-beauty-outside.html
 |  | /it-it/article-skincare-grooming-tips-for-him.html
 |  | /it-it/article-skincare-beauty-routines.html
 |  | /it-it/article-skincare-sleep-problems.html
 |  | /it-it/article-skincare-5-tips-great-night-of-sleep.html
 |  | /it-it/article-skincare-sleep-better-tips.html
 |  | /it-it/article-skincare-sleeping-routine.html
 |  | /it-it/article-skincare-what-sleep-does-for-your-body.html
 |  | /pl-pl/article-skin-purification.html
 |  | /pl-pl/article-beauty-outside.html
 |  | /pl-pl/article-skincare-grooming-tips-for-him.html
 |  | /pl-pl/article-skincare-beauty-routines.html
 |  | /pl-pl/article-skincare-sleep-problems.html
 |  | /pl-pl/article-skincare-5-tips-great-night-of-sleep.html
 |  | /pl-pl/article-skincare-sleep-better-tips.html
 |  | /pl-pl/article-skincare-sleeping-routine.html
 |  | /pl-pl/article-skincare-what-sleep-does-for-your-body.html
 |  | /pt-pt/article-skin-purification.html
 |  | /pt-pt/article-beauty-outside.html
 |  | /pt-pt/article-skincare-grooming-tips-for-him.html
 |  | /pt-pt/article-skincare-beauty-routines.html
 |  | /pt-pt/article-skincare-sleep-problems.html
 |  | /pt-pt/article-skincare-5-tips-great-night-of-sleep.html
 |  | /pt-pt/article-skincare-sleep-better-tips.html
 |  | /pt-pt/article-skincare-sleeping-routine.html
 |  | /pt-pt/article-skincare-what-sleep-does-for-your-body.html
 |  | /el-gr/article-skin-purification.html
 |  | /el-gr/article-beauty-outside.html
 |  | /el-gr/article-skincare-grooming-tips-for-him.html
 |  | /el-gr/article-skincare-beauty-routines.html
 |  | /el-gr/article-skincare-sleep-problems.html
 |  | /el-gr/article-skincare-5-tips-great-night-of-sleep.html
 |  | /el-gr/article-skincare-sleep-better-tips.html
 |  | /el-gr/article-skincare-sleeping-routine.html
 |  | /el-gr/article-skincare-what-sleep-does-for-your-body.html
 |  | /lt-lt/article-skin-purification.html
 |  | /lt-lt/article-beauty-outside.html
 |  | /lt-lt/article-skincare-grooming-tips-for-him.html
 |  | /lt-lt/article-skincare-beauty-routines.html
 |  | /lt-lt/article-skincare-sleep-problems.html
 |  | /lt-lt/article-skincare-5-tips-great-night-of-sleep.html
 |  | /lt-lt/article-skincare-sleep-better-tips.html
 |  | /lt-lt/article-skincare-sleeping-routine.html
 |  | /lt-lt/article-skincare-what-sleep-does-for-your-body.html
 |  | /hr-hr/article-skin-purification.html
 |  | /hr-hr/article-beauty-outside.html
 |  | /hr-hr/article-skincare-grooming-tips-for-him.html
 |  | /hr-hr/article-skincare-beauty-routines.html
 |  | /hr-hr/article-skincare-sleep-problems.html
 |  | /hr-hr/article-skincare-5-tips-great-night-of-sleep.html
 |  | /hr-hr/article-skincare-sleep-better-tips.html
 |  | /hr-hr/article-skincare-sleeping-routine.html
 |  | /hr-hr/article-skincare-what-sleep-does-for-your-body.html
 |  | /fi-fi/article-skin-purification.html
 |  | /fi-fi/article-beauty-outside.html
 |  | /fi-fi/article-skincare-grooming-tips-for-him.html
 |  | /fi-fi/article-skincare-beauty-routines.html
 |  | /fi-fi/article-skincare-sleep-problems.html
 |  | /fi-fi/article-skincare-5-tips-great-night-of-sleep.html
 |  | /fi-fi/article-skincare-sleep-better-tips.html
 |  | /fi-fi/article-skincare-sleeping-routine.html
 |  | /fi-fi/article-skincare-what-sleep-does-for-your-body.html
 |  | /bg-bg/article-skin-purification.html
 |  | /bg-bg/article-beauty-outside.html
 |  | /bg-bg/article-skincare-grooming-tips-for-him.html
 |  | /bg-bg/article-skincare-beauty-routines.html
 |  | /bg-bg/article-skincare-sleep-problems.html
 |  | /bg-bg/article-skincare-5-tips-great-night-of-sleep.html
 |  | /bg-bg/article-skincare-sleep-better-tips.html
 |  | /bg-bg/article-skincare-sleeping-routine.html
 |  | /bg-bg/article-skincare-what-sleep-does-for-your-body.html
 |  | /sl-si/article-skin-purification.html
 |  | /sl-si/article-beauty-outside.html
 |  | /sl-si/article-skincare-grooming-tips-for-him.html
 |  | /sl-si/article-skincare-beauty-routines.html
 |  | /sl-si/article-skincare-sleep-problems.html
 |  | /sl-si/article-skincare-5-tips-great-night-of-sleep.html
 |  | /sl-si/article-skincare-sleep-better-tips.html
 |  | /sl-si/article-skincare-sleeping-routine.html
 |  | /sl-si/article-skincare-what-sleep-does-for-your-body.html
 |  | /nl-be/article-skin-purification.html
 |  | /nl-be/article-beauty-outside.html
 |  | /nl-be/article-skincare-grooming-tips-for-him.html
 |  | /nl-be/article-skincare-beauty-routines.html
 |  | /nl-be/article-skincare-sleep-problems.html
 |  | /nl-be/article-skincare-5-tips-great-night-of-sleep.html
 |  | /nl-be/article-skincare-sleep-better-tips.html
 |  | /nl-be/article-skincare-sleeping-routine.html
 |  | /nl-be/article-skincare-what-sleep-does-for-your-body.html
 |  | /es-es/article-skin-purification.html
 |  | /es-es/article-beauty-outside.html
 |  | /es-es/article-skincare-grooming-tips-for-him.html
 |  | /es-es/article-skincare-beauty-routines.html
 |  | /es-es/article-skincare-sleep-problems.html
 |  | /es-es/article-skincare-5-tips-great-night-of-sleep.html
 |  | /es-es/article-skincare-sleep-better-tips.html
 |  | /es-es/article-skincare-sleeping-routine.html
 |  | /es-es/article-skincare-what-sleep-does-for-your-body.html
 |  | /en-us/article-skin-purification.html
 |  | /en-us/article-beauty-outside.html
 |  | /en-us/article-skincare-grooming-tips-for-him.html
 |  | /en-us/article-skincare-beauty-routines.html
 |  | /en-us/article-skincare-sleep-problems.html
 |  | /en-us/article-skincare-5-tips-great-night-of-sleep.html
 |  | /en-us/article-skincare-sleep-better-tips.html
 |  | /en-us/article-skincare-sleeping-routine.html
 |  | /en-us/article-skincare-what-sleep-does-for-your-body.html
 |  | /en-gb/article-skin-purification.html
 |  | /en-gb/article-beauty-outside.html
 |  | /en-gb/article-skincare-grooming-tips-for-him.html
 |  | /en-gb/article-skincare-beauty-routines.html
 |  | /en-gb/article-skincare-sleep-problems.html
 |  | /en-gb/article-skincare-5-tips-great-night-of-sleep.html
 |  | /en-gb/article-skincare-sleep-better-tips.html
 |  | /en-gb/article-skincare-sleeping-routine.html
 |  | /en-gb/article-skincare-what-sleep-does-for-your-body.html