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