How do I set a Gtk.StatusIcon as Text?

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.

Sohil Bhagat at Quora Visit the source

Was this solution helpful to you?

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.