+ Reply to Thread
Results 1 to 5 of 5

Search the text in 3rd cell by using texts in 2 cells

  1. #1
    Registered User
    Join Date
    05-02-2014
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2

    Search the text in 3rd cell by using texts in 2 cells

    I have put my question in the attached file with example. Please help
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Search the text in 3rd cell by using texts in 2 cells

    in D9
    =INDEX(J$9:M$27,MATCH(B9,I$9:I$27,0),MATCH(C9,J$8:M$8,0))

    and copy down
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: Search the text in 3rd cell by using texts in 2 cells

    Hello Shinaz ! Welcome to the forum ! You have duplicates also like Task manager is available two times In new ID as well as two times you have specified to search do you want first time first occurrence and so on.
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST

    More we learn about excel, more it shows us, how less we know about it.

    for chemistry
    https://www.youtube.com/c/chemistrybyshivaansh

  4. #4
    Registered User
    Join Date
    05-02-2014
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Search the text in 3rd cell by using texts in 2 cells

    The solution provide by Special-K does it for me. Brilliant. Thank you. Happy to have joined this forum.

  5. #5
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: Search the text in 3rd cell by using texts in 2 cells

    Are you sure enough.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA to combine texts from cells to a single based on another cell value
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-04-2013, 10:05 AM
  2. Append texts into one string from 4 cells that each cell has a formula
    By Rocky2013 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-28-2013, 09:57 AM
  3. Replies: 3
    Last Post: 10-25-2012, 12:49 AM
  4. Search Cells and Replace Text in that cell
    By lennonjunior in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-05-2009, 11:45 PM
  5. find for any of some search texts within a text
    By xirx in forum Excel General
    Replies: 2
    Last Post: 06-15-2005, 01:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1