How to split column text to another column?

Microsoft Excel: Chk the text string in particular cell, compare it with a super set column and get the full from of the text string from another corresponsing column and the output will be corresponsing full form of the chked text string?

• I have a set of text strings in one column, and a super set of those text strings in adjacent column and full form of the super set text string in the next column.

• Answer:

  The question as-is is tough to understand. But i'll try to answer on the basis of what I understand. I assume that your first column of text string is column A and it is filled from A1 to A10. Further, your columns that contain the super set of text strings and the corresponding longer text strings are columns B and C and they are filled from rows 1 to 20. Now, my understanding of your question is that for each string in column A, you need to find the matching text string in column B and then show as output the corresponding longer string from column C. Assuming that your output column is column D, the formula I'd use for D1 is: D1 =INDEX($C$1:$C$20,MATCH(A1,$B$1:$B$20,0)) Let me know if this works, or if I've misinterpreted the question.