Vlookup where table arrary contains certain value [Closed]

Report
Posts
1
Registration date
Saturday June 16, 2018
Status
Member
Last seen
June 16, 2018
-
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