Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

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



See more
Related: