Vlookup where table arrary contains certain value

Closed
_Liv_
Posts
1
Registration date
Saturday June 16, 2018
Status
Member
Last seen
June 16, 2018
- Jun 16, 2018 at 02:57 AM
Hello,
I have a "Key"

Code Value
000 Black
123 White

and another sheet with the data below

Data Colour
BKI000T
GTEF123X
LKJH000VC
XZSW123QW

I would to search the data column if I find 000, I return Black in the colour column. If I get 123 I return White