#1
|
|||
|
|||
Index and Match functions
I have the following Data in Column A-
Column A aman has email aman@gmail.com tom has email tom@yahoo.com John has email john@company.com mike has email mike@industry.com In column C I have the following data- Column C gmail yahoo I need to search for the text in Column C in the string of texts in Column A and return the following - Column A Column B Column C aman has email aman@gmail.com gmail yahoo tom has email tom@yahoo.com yahoo gmail John has email john@company.com mike has email mike@industry.com I have used the following query- INDEX($C$1:$C$2,MATCH(1,COUNTIF(A1,"*"&$C$1:$C$2&" *"),0)) But it is giving me wrong result- Column A Column B Column C aman has email aman@gmail.com #N/A yahoo tom has email tom@yahoo.com #N/A gmail John has email john@company.com #N/A mike has email mike@industry.com #N/A Can someone please help. |
#2
|
|||
|
|||
It is not clear to me what you have in column A, column B and column C and what you want.
|
Tags |
excel 2013 formula, index, match/index |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
index / match Formula | dmcg9760 | Excel Programming | 1 | 11-08-2015 03:16 PM |
Translate INDEX(MATCH) into VBA | grexcelman | Excel Programming | 1 | 03-08-2015 05:06 PM |
Index match vba | grexcelman | Excel | 0 | 03-05-2015 10:55 PM |
Index Match syntax | grexcelman | Excel Programming | 0 | 03-05-2015 07:17 AM |
UDF multiple IFs INDEX-MATCH | grexcelman | Excel Programming | 0 | 02-22-2015 04:20 PM |