Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort or Filter option? | Excel Worksheet Functions | |||
search for same text | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
search multiple worksheets name with common text and process using | Excel Worksheet Functions | |||
Newbie: How to search a text string from right | Excel Worksheet Functions |