how to lookup the words which is inside the sentence and using lookup formula to get data?

**sagarkarki69** · 07-22-2021, 08:07 AM

Dear all,
as given below how can I bring the channel code by searching the words available in channel inside the outlet names .

OUTLET NAME CHANNEL CODE CHANNEL CHANNEL CODE
DANISH RESTAURENT RESTAURENT SC22
SATYA STORE MOMO SC22
B AND B Cafe Cafe SC22
DIBYA HOTEL AND LODGE HOTEL SC22
KIMCHI COLD DRINKS COLD SC05
RAMESH MOMO PASAL STORE SC05
TRISHARA RESTAURENT AND CLUB
DÉJÀ VU RESTAURENT
QUALITY MOMO PVT LTD

excel file is attached to the thread.
kind regards,

**XLent** · 07-22-2021, 08:51 AM

one option

Formula:

Please Login or Register  to view this content.

**samba_ravi** · 07-22-2021, 08:52 AM

b2=LOOKUP(2,1/SEARCH($H$2:$H$7,$A2),$I$2:$I$7)
try this copy and paste towards down

how to lookup the words which is inside the sentence and using lookup formula to get data?

LinkBack

Thread Tools

Rate This Thread

Display

how to lookup the words which is inside the sentence and using lookup formula to get data?

Re: how to lookup the words which is inside the sentence and using lookup formula to get d

Re: how to lookup the words which is inside the sentence and using lookup formula to get d

Thread Information

Users Browsing this Thread

Similar Threads

Lookup Matching Word withing A Sentence

Lookup inside of IF(AND Formula Not Working

[SOLVED] Multiple Result Lookup inside Data Validation List

Count formula that will look for multiple words and multiply their lookup

Heading Lookup inside Column Data

lookup or search text in sentence that match with keyword

Finding 2 or More specific words in a sentence inside a Cell in Excel 2007

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions