Vlookup where table arrary contains certain value

[Closed]

Report

_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

Vlookup where table arrary contains certain value
VLOOKUP table_array parameter as a variable ✓ - Forum - Office Software
Table fit to page html - How-To - HTML
Excel data validation list from table multiple columns - How-To - Excel
How to screenshot excel table - How-To - Excel
How to delete part of a table in word - How-To - Word

Vlookup where table arrary contains certain value

Your reply

Subscribe To Our Newsletter!