Ask Experts Questions for FREE Help !
Ask
    nikeshtnt's Avatar
    nikeshtnt Posts: 52, Reputation: 1
    Junior Member
     
    #1

    Sep 16, 2008, 12:19 AM
    Finding the given text in different columns and place in other column
    I have a worksheet where two columns contains name. I need to check that if one name is appering in any of these two columns then result shoule be shown in third column or if that name is not there then third column should be blank.

    If We have to find KEVIN MERRITT then result should be like this

    Name 1 Name 2 Result
    Mr ANDREW OSBORN Mr KEVIN MERRITT KEVIN MERRITT
    Mr NEIL CALDWELL Mr MOHAMMED KHAN
    Mr KEVIN MERRITT Mr NEIL CALDWELL KEVIN MERRITT
    Mr MOHAMMED KHAN Miss HELEN JOHNSON
    Mr KEVIN MERRITT Mr NEIL CALDWELL KEVIN MERRITT
    Miss HELEN JOHNSON Mr MOHAMMED KHAN
    Mr ANDREW OSBORN Miss HELEN JOHNSON
    Mr NEIL CALDWELL Miss HELEN JOHNSON
    Mr KEVIN MERRITT Mr MOHAMMED KHAN KEVIN MERRITT
    Mr MOHAMMED KHAN Mr KEVIN MERRITT KEVIN MERRITT
    Mr KEVIN MERRITT Miss HELEN JOHNSON KEVIN MERRITT
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #2

    Sep 16, 2008, 05:26 AM
    Column A = Name 1
    Column B = Name 2
    Column C = Result

    List starts in row 2.

    The formula you put in cell C2 is:
    =IF(OR(A1="Mr Kevin Merritt",B1="Mr Kevin Merritt"),"KEVIN MERRITT","")

    Now copy that formula down to C3... etc.
    Attached Images
     
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #3

    Sep 16, 2008, 10:45 AM
    nikeshtnt agrees: You are too good
    SO that's going to work for you?

    The only downside to this method is that it requires the spelling of "Mr Kevin Merritt" to be exactly correct in one of the two columns to get the KEVIN MERRITT to appear in the third.

    I know there's a way to watch for "part" of the text in a cell, but my head hurts when I start to think about it.

    Good luck with your sheet. Come back if you get stuck again.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Excel 15 digit issue, tried converting to text, text to column feature negates fix [ 6 Answers ]

I have the following numbers that exceed 15 characters that needs to be split into its own columns. Down the road, there would be thousands of such rows of data with the first couple set of unique numbers. 890432453253208820,5004500558,05CC,1,0,0,0,0,0,0, 0000,5.0000,2007-01-11...

Finding a text book [ 1 Answers ]

I need help fnding a literature textbook that can help me with my homework:confused: :confused:

Finding a place [ 4 Answers ]

I hope this is the right place to post this. Anyway, I plan on moving to Raleigh NC, and was wondering (seen how I'm having so much trouble) if anyone knew of any apartments that are NOT in a complex. I'm not really a fan of apartment complexes, and was wondering if there were any actual...

Finding a place to live [ 1 Answers ]

My fiance and I are hoping to buy our own home, or to build a house in the next year or so, however right now our credit is ony giving us about $117,000 loan amount. Will that amount grow in the next year, and about how much? Also, what is the least amount and average amount a person would have to...

Finding highlighted text in IE [ 4 Answers ]

I use a program that returns a search result in a html page with the various keywords highlighted. Is there an IE add on that will allow me to find the first instance of a highlighted word and subsequentially the next and the next? I prefer it to be in IE but other browsers would be acceptable.


View more questions Search