| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match word in one column to another
Could it search for "Delicious Orange" as an entire phrase?
Yes of course. If it is as an entire phrase, then my original response should have worked. You might want to fortify it a bit more by using TRIM around A1, since the search string (the entire phrase) now contains a single space: =INDEX(B$1:B$3,MATCH(TRUE,INDEX(ISNUMBER(SEARCH($B $1:$B$3,TRIM(A1))),),0)) If this response helped in any way, do press the YES button below -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:365 Subscribers:65 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to match 2 columns, if a match found add info from 2nd column | Excel Worksheet Functions | |||
| Match using array of column and row references to match with | Excel Worksheet Functions | |||
| match word in one column form list in another | Excel Worksheet Functions | |||
| Any way for 2 column vlookups. i.e match last name then match firs | Excel Worksheet Functions | |||
| need formula to search column for a word and return another word | Excel Discussion (Misc queries) | |||
Hybrid Mode
