Excel Forum

How to search a Key word in a Column

kev van

New Member

Members

Forum Posts: 1

Member Since:
June 2, 2020

Offline

June 2, 2020 - 3:04 am

Hi,

I want to be able to vlookup a key word within a lot of text in a cell. IE Column A I want to lookup the column for "TOWER"

Thanks in advance for the help.

A	B
MOBILE: LIGHT TOWER	07047N
MOBILE: LIGHT TOWER	07047N
CONTAINER SHIPPING AND STORAGE, FIBERGLASS 62W X 42D X 60H NET W	47028N
CONTAINER SHIPPING AND STORAGE, FIBERGLASS 62W X 42D X 60H NET W	47028N
CONTAINER SHIPPING AND STORAGE, FIBERGLASS 62W X 42D X 60H NET W	47028N
POWER SUPPLY ASSEMBLY, TYX	63026N
POWER SUPPLY ASSEMBLY, TYX	63026N
POWER SUPPLY ASSEMBLY, TYX	63026N
POWER SUPPLY ASSEMBLY, TYX	63026N
PROJECTOR/REVIEWER/EDITOR	70014N
SCREEN PROJECTION UNIT	70019N
SCREEN PROJECTION UNIT	70019N
SCREEN PROJECTION UNIT	70019N

Purfleet

England

Member

Members

Trusted Members

Forum Posts: 412

Member Since:
December 20, 2019

Offline

June 2, 2020 - 3:16 pm

Hi Kev

You can wrap what you are looking for in * (wild card)

Index & match - =INDEX($B$2:$B$14,MATCH("*"&E2&"*",$A$2:$A$14,0))

VLOOKUP - =VLOOKUP("*"&E2&"*",$A$2:$B$14,2,FALSE)

Purfleet

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 245

Currently Online: Amin Khajeh

Guest(s) 10

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1432

Anders Sehlstedt: 870

Purfleet: 412

Frans Visser: 346

David_Ng: 306

lea cohen: 219

A.Maurizio: 202

Jessica Stewart: 202

Aye Mu: 201

jaryszek: 183

Newest Members:

Lawrence Miu

Jo Saies

Paul Pritchard

Monique Roussouw

Keith Aul

Richard Dunks

Manjula Mangalmurti

Thomas Quidort

Jamie Preece

Bob Smith

Forum Stats:

Groups: 3

Forums: 24

Topics: 6192

Posts: 27146

Member Stats:

Guest Posters: 49

Members: 31848

Moderators: 3

Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT

Moderators: MOTH Support, Velouria, Riny van Eekelen