How do I search for text within text?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do you search for text within text and then when you find a match, return
the information in the next column?

I usually use the functions index(match) to do the above. Unfortunately,
the function only works when there is a identical match.

So, I need to find 765849 in 111765849111 and then return the next column.

Thanks, I really appreciate the help!

Best regards,

Dave
 
Hi!

If the values were really text, you could use wildcards
with either Vlookup or Match. However, neither seems to
work with numeric numbers. So, try this array formula
entered with the key combo of CTRL,SHIFT,ENTER:

With the lookup value in C1: 765849

=INDEX(B1:B10,MATCH(TRUE,ISNUMBER(SEARCH(C1,A1:A10)),0))

Biff
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding Text within an Array 2
Index/match across multiple columns? 19
Problem searching cell text 3
Weighted randbetween text list 3
Macro: finding a cell on one worksheet and copying to another worksheet 0
Text Search in an Array 1
How to search for text within a cell? 9
Search range for text not in another range 3

Back
Top