Spreadsheet: 691153d1597514044-need-formula-to-extract-text-value-from-cell-based-on-another-column-need-formula
Sheet: Sheet1

ModelColourPeriod | ModelColour | Model | Colour
V19(8+128G)Piano BlackInventory at beginning of the period | V19(8+128G)Piano Black | Y19(8+128G)
Y30(4+128G)Dazzle BlueInventory at beginning of the period | Y30(4+128G)Dazzle Blue | Y30(4+128G)
Y12(3+64G)Burgundy RedInventory at beginning of the period | Y12(3+64G)Burgundy Red | Y12(3+64G)
V9YouthGoldInventory at beginning of the period | V9YouthGold | Y9Youth
Y83 ProNebula PurpleInventory at beginning of the period | Y83 ProNebula Purple | Y83 Pro
V17(8+128G)Glacier IceInventory at beginning of the period | V17(8+128G)Glacier Ice | Y17(8+128G)
Y91i(2+32G)BlackInventory at beginning of the period | Y91i(2+32G)Black | Y91i(2+32G)
V5sCrown GoldInventory at beginning of the period | V5sCrown Gold | Y5s
Y81(4+32G)GoldInventory at beginning of the period | Y81(4+32G)Gold | Y81(4+32G)
Y71(4G)GoldInventory at beginning of the period | Y71(4G)Gold | [NAME])
Y12(4+32G)Burgundy RedInventory at beginning of the period | Y12(4+32G)Burgundy Red | Y12(4+32G)
Y81GoldInventory at beginning of the period | Y81Gold | Y81
Y71iBlackInventory at beginning of the period | Y71iBlack | Y71i
Y69GoldInventory at beginning of the period | Y69Gold | Y69
Y11(3+32G)Mineral BlueInventory at beginning of the period | Y11(3+32G)Mineral Blue | Y11(3+32G)
Y53iCrown GoldInventory at beginning of the period | Y53iCrown Gold | Y53i
Y91i(2+32G)Fusion BlackInventory at beginning of the period | Y91i(2+32G)Fusion Black | Y91i2+32G)
V11(6+64G)BlackInventory at beginning of the period | V11(6+64G)Black | V11(6+64G)
Y12(3+64G)Aqua BlueInventory at beginning of the period | Y12(3+64G)Aqua Blue | Y12(3+64G)
V17Pro(8+128G)Glacier IceInventory at beginning of the period | V17Pro(8+128G)Glacier Ice | [NAME]G)
Y15(4+64G)RedInventory at beginning of the period | Y15(4+64G)Red | Y15(4+64G)
V19(8+256G)Mystic SilverInventory at beginning of the period | V19(8+256G)Mystic Silver | Y19(8+256G)
Y50(8+128G)Pearl WhiteInventory at beginning of the period | Y50(8+128G)Pearl White | Y50(8+128G)
V11Pro(6+64G)BlackInventory at beginning of the period | V11Pro(6+64G)Black | V11 Pro(6+64G)
Y71(3G)BlackInventory at beginning of the period | Y71(3G)Black | [NAME])
S1(6+64G)Diamond BlackInventory at beginning of the period | S1(6+64G)Diamond Black | Y166+64G)
Y21LGreyInventory at beginning of the period | Y21LGrey | Y21
V9Pro(6+64G)BlackInventory at beginning of the period | V9Pro(6+64G)Black | V9 Pro(6+64G)
[NAME] ProGoldInventory at beginning of the period | Y83 ProGold | Y83 Pro
Y81iBlackInventory at beginning of the period | Y81iBlack | Y81i
S1(4+128G)Skyline BlueInventory at beginning of the period | S1(4+128G)Skyline Blue | Y144+128G)
Y71iGoldInventory at beginning of the period | Y71iGold | Y71i
V17(8+128G)Midnight OceanInventory at beginning of the period | V17(8+128G)Midnight Ocean | Y17(8+128G)
V15(6+64G)RedInventory at beginning of the period | V15(6+64G)Red | V15(6+64G)
Y19(128G+4G)Magnetic BlackInventory at beginning of the period | Y19(128G+4G)Magnetic Black | Y19(128G+4G)
S1 Pro(8+128G)Mystic BlackInventory at beginning of the period | S1 Pro(8+128G)Mystic Black | Y1PPro(8+128G)
V7+BlueInventory at beginning of the period | V7+Blue | V7+
Y53BlackInventory at beginning of the period | [NAME] | Y53
[NAME] BlackInventory at beginning of the period | [NAME] Black | Y50(8+128G)
S1 Pro(8+128G)Dreamy WhiteInventory at beginning of the period | S1 Pro(8+128G)Dreamy White | Y1PPro(8+128G)
V11Pro(6+64G)RedInventory at beginning of the period | V11Pro(6+64G)Red | V11 Pro(6+64G)
V15Pro(6+128G)BlueInventory at beginning of the period | V15Pro(6+128G)Blue | V15 Pro(6+128G)
[NAME] BlueInventory at beginning of the period | [NAME] | Y50(8+128G)
Y91(2+32G)BlueInventory at beginning of the period | Y91(2+32G)Blue | Y91(2+32G)
V15(6+64G)Aqua BlueInventory at beginning of the period | V15(6+64G)Aqua Blue | Y15(6+64G)
V15(6+64G)BlackInventory at beginning of the period | V15(6+64G)Black | V15(6+64G)
S1(6+64G)Skyline BlueInventory at beginning of the period | S1(6+64G)Skyline Blue | Y166+64G)
Y93(3+64G)Nebula PurpleInventory at beginning of the period | Y93(3+64G)Nebula Purple | Y93(3+64G)
S1(6+128G)Diamond BlackInventory at beginning of the period | S1(6+128G)Diamond Black | Y166+128G)
Y93(4+32G)BlackInventory at beginning of the period | Y93(4+32G)Black | Y93(4+32G)
Y91(3+32G)Starry BlackInventory at beginning of the period | Y91(3+32G)Starry Black | Y91(3+32G)
Y91i(3+32G)BlackInventory at beginning of the period | Y91i(3+32G)Black | Y91i(3+32G)
U20(8+128G)Blaze BlueInventory at beginning of the period | U20(8+128G)Blaze Blue | Y20(8+128G)
V15(6+64G)BlueInventory at beginning of the period | V15(6+64G)Blue | V15(6+64G)
[NAME] ProBlackInventory at beginning of the period | [NAME] | Y83 Pro
Y91(3+32G)Nebula PurpleInventory at beginning of the period | Y91(3+32G)Nebula Purple | Y91(3+32G)
[NAME] at beginning of the period | [NAME] | [NAME])
V15Pro(6+128G)RedInventory at beginning of the period | V15Pro(6+128G)Red | V15 Pro(6+128G)
Y69BlackInventory at beginning of the period | Y69Black | Y69
V19(8+256G)Piano BlackInventory at beginning of the period | V19(8+256G)Piano Black | Y19(8+256G)
[NAME] at beginning of the period | [NAME] | [NAME])
NEXBlackInventory at beginning of the period | NEXBlack | NEX
V15Pro(8+128G)BlueInventory at beginning of the period | V15Pro(8+128G)Blue | [NAME]128G)
Y91i(3+32G)Ocean BlueInventory at beginning of the period | Y91i(3+32G)Ocean Blue | Y91i3+32G)
Y71(4G)BlackInventory at beginning of the period | Y71(4G)Black | [NAME])
Y15(4+64G)Aqua BlueInventory at beginning of the period | Y15(4+64G)Aqua Blue | Y15(4+64G)
Y17(4+128G)Mystic PurpleInventory at beginning of the period | Y17(4+128G)Mystic Purple | Y17(4+128G)
Y21LWhiteInventory at beginning of the period | Y21LWhite | Y21
Y19(128G+4G)Spring WhiteInventory at beginning of the period | [NAME] | Y19(128G+4G)
[NAME] BlueInventory at beginning of the period | [NAME] | Y50(8+256G)
X50(8+256G)Glaze BlackInventory at beginning of the period | [NAME] | Y50(8+256G)
Y55s(3G)Crown GoldInventory at beginning of the period | Y55s(3G)Crown Gold | [NAME])
Y81iGoldInventory at beginning of the period | Y81iGold | Y81i
Y93(3+64G)BlackInventory at beginning of the period | Y93(3+64G)Black | Y93(3+64G)
V9Pro(6+64G)Nebula PurpleInventory at beginning of the period | V9Pro(6+64G)Nebula Purple | Y9r6+64G)
V17Pro(8+128G)Midnight OceanInventory at beginning of the period | V17Pro(8+128G)Midnight Ocean | [NAME]G)
Y95(4+64G)BlackInventory at beginning of the period | Y95(4+64G)Black | Y95(4+64G)
Y53Crown GoldInventory at beginning of the period | Y53Crown Gold | Y53
S1 Pro(8+128G)Jazzy BlueInventory at beginning of the period | S1 Pro(8+128G)Jazzy Blue | Y1PPro(8+128G)
Y51LWhiteInventory at beginning of the period | Y51LWhite | [NAME]
Y12(4+32G)Aqua BlueInventory at beginning of the period | Y12(4+32G)Aqua Blue | Y12(4+32G)
V7+GoldInventory at beginning of the period | V7+Gold | V7+
S1(6+128G)Skyline BlueInventory at beginning of the period | S1(6+128G)Skyline Blue | Y166+128G)
Y17(4+128G)BlueInventory at beginning of the period | Y17(4+128G)Blue | Y17(4+128G)
Y50(8+128G)Iris BlueInventory at beginning of the period | Y50(8+128G)Iris Blue | Y50(8+128G)
[NAME] at beginning of the period | [NAME] Grey | Y50 Pro(8+256G)
S1(4+128G)Fusion BlackInventory at beginning of the period | S1(4+128G)Fusion Black | Y144+128G)
Y55s(3G)BlackInventory at beginning of the period | Y55s(3G)Black | Y55s(3G)
Y83GoldInventory at beginning of the period | Y83Gold | Y83
Y91i(2+32G)Ocean BlueInventory at beginning of the period | Y91i(2+32G)Ocean Blue | Y91i2+32G)
Y71(3G)GoldInventory at beginning of the period | Y71(3G)Gold | [NAME])
Y83BlackInventory at beginning of the period | Y83Black | Y83
V11(6+64G)Nebula PurpleInventory at beginning of the period | V11(6+64G)Nebula Purple | Y11(6+64G)
Y93(4+32G)Nebula PurpleInventory at beginning of the period | Y93(4+32G)Nebula Purple | Y93(4+32G)
[NAME] at beginning of the period | [NAME] Black | Y144+128G)
V15Pro(8+128G)RedInventory at beginning of the period | V15Pro(8+128G)Red | [NAME]128G)
V11Pro(6+64G)GoldInventory at beginning of the period | V11Pro(6+64G)Gold | V11 Pro(6+64G)
V19(8+128G)Mystic SilverInventory at beginning of the period | V19(8+128G)Mystic Silver | Y19(8+128G)
Y11(3+32G)Agate RedInventory at beginning of the period | Y11(3+32G)Agate Red | Y11(3+32G)
Y81BlackInventory at beginning of the period | Y81Black | Y81
V7+BlackInventory at beginning of the period | V7+Black | V7+
V7GoldInventory at beginning of the period | V7Gold | V7
V7BlackInventory at beginning of the period | V7Black | V7
Y95(4+64G)Nebula PurpleInventory at beginning of the period | Y95(4+64G)Nebula Purple | Y95(4+64G)
Y91(2+32G)BlackInventory at beginning of the period | Y91(2+32G)Black | Y91(2+32G)
Y91i(3+32G)Fusion BlackInventory at beginning of the period | Y91i(3+32G)Fusion Black | Y91i3+32G)
Y30(4+128G)Emerald BlackInventory at beginning of the period | Y30(4+128G)Emerald Black | Y30(4+128G)
X21BlackInventory at beginning of the period | X21Black | X21
Y81(4+32G)BlackInventory at beginning of the period | Y81(4+32G)Black | Y81(4+32G)