+ Reply to Thread
Results 1 to 8 of 8

Find specific cells in excel and copy to adjacent cells corresponding values

  1. #1
    Registered User
    Join Date
    12-04-2012
    Location
    Nesher, Israel
    MS-Off Ver
    Excel 2007
    Posts
    8

    Find specific cells in excel and copy to adjacent cells corresponding values

    Hello,
    I have a huge amount of entries, from which I need to find specific cells that match strings in another sheet. To every match, I need to copy to adjacent cell a corresponding date. For example, the strings to be found: "1234", "5678", "9644".. and if found, I need to write next to each of them a specific corresponding date from another sheet.
    I tried using the formula: if(isnumber(search(the range of cells, the range of target cells)),the range of corresponding dates,"no), however this could work only for one cell but not a range.
    I would be very grateful if someone could help me on this.

    Have a nice day

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: Find specific cells in excel and copy to adjacent cells corresponding values

    Please attach a sample workbook with expected out which will be helpful to us for giving solution for your query.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,193

    Re: Find specific cells in excel and copy to adjacent cells corresponding values

    Hi, srolash,

    have you tried the functions VLookUp or Index/Match to solve your problem (please note that the search ranges should be absolute when filling down the formula)? From what has been written I doubt a mcaro to be necessary.

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  4. #4
    Registered User
    Join Date
    12-04-2012
    Location
    Nesher, Israel
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Find specific cells in excel and copy to adjacent cells corresponding values

    Dear Sixthsense,
    I have attached two example spreadsheets; the value_spreadsheet that contains the specific I.Ds to be searched in the target_spreadsheet, and once found, the corresponding dates to be copied to adjacent column in the target_spreadsheet.
    Thanks for your interest and intention to help, which I need desperately.

    Cheers
    Attached Files Attached Files

  5. #5
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: Find specific cells in excel and copy to adjacent cells corresponding values

    Keep both the files open and apply the below formula.

    In B2 cell of Target_spreadsheet.xlsx
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Drag it down.

    Format Column-B as date.

  6. #6
    Registered User
    Join Date
    12-04-2012
    Location
    Nesher, Israel
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Find specific cells in excel and copy to adjacent cells corresponding values

    Dear Holger,

    Yes I have tried these functions, but since I'm not a big expert in excel, I did not know how to write their syntax correctly, and this yielded error
    If you know how to use them, I would be more than glad if you could show me.

    Ciao,
    srolash

  7. #7
    Registered User
    Join Date
    12-04-2012
    Location
    Nesher, Israel
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Find specific cells in excel and copy to adjacent cells corresponding values

    Dear Sixthsense,
    That's really awesome, it worked perfectly!!
    However, the data I just supplied is not the real confidential data, and I need to copy the formula to the real documents, but I could not understand the syntax; if it's not a bother to you, could you explain to me what's written in it, I know it's a big favor!!

    Thanksssss again,
    srolash

  8. #8
    Registered User
    Join Date
    12-04-2012
    Location
    Nesher, Israel
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Find specific cells in excel and copy to adjacent cells corresponding values

    Dear Sixthsense and all,

    I think I figured it out (I mean the vlookup formula). Really, I am speechless and very grateful for your willing to help.

    Have a nice day
    Srolash

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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