How do I search for text within text?
 

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

-----Original Message-----
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
.