+ Reply to Thread
Results 1 to 3 of 3

Formula needed to search data then copy into different cell if found

  1. #1
    Registered User
    Join Date
    04-01-2016
    Location
    Macclesfield England
    MS-Off Ver
    2013
    Posts
    2

    Formula needed to search data then copy into different cell if found

    Hi I am new to this forum and am hoping some one can help please.

    I have alot of data that I need to find certain references within, all this reference are typically around 15 characters long but all start with "0062000" and they contain both numerical and alphabetical characters. I need a formula that will search the whole spreadsheet and locate the references then once it has copy the reference into a new cell/column.

    Is this possible, can anyone help please?

    Any advice greatly received.

    Thanks
    Liz

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

    Re: Formula needed to search data then copy into different cell if found

    Cells can't copy to other cells, you need VBA for that, so that's one solution.
    However, you can give a cell a value dependant on the result of another cell.
    e.g.
    A1="0062000ABCDE"
    A2="0063000ABCDE"

    then in B1
    =IF(LEFT(A1,7)="0062000",A1,"")
    in B2
    =IF(LEFT(A2,7)="0062000",A2,"")

    B1 would be "0062000ABCDE"
    but B2 would be blank (since the first 7 characters of A2 are "0063000"
    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
    Registered User
    Join Date
    04-01-2016
    Location
    Macclesfield England
    MS-Off Ver
    2013
    Posts
    2

    Re: Formula needed to search data then copy into different cell if found

    Hi Special-K,

    Thanks for your response. this is great and much closer than I was previously, however I need it to just pick up the actual reference it has found and copy that into the separate cell and not everything contained within the cell, do you know if that is possible at all please?

    Thanks,
    Liz

+ 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. [SOLVED] Formula Needed to copy data from a cell based on data entered into another cell
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-10-2013, 03:16 AM
  2. Macro to search external file for a value and copy each row of data found
    By noxidnai in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-07-2013, 12:42 PM
  3. [SOLVED] Formula needed to return the text adjacent to the cell when found.
    By LMWI65 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-16-2012, 08:18 AM
  4. Search Data from Multiple Sheets and copy found data to new workbook
    By xenith1988 in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 06-26-2012, 12:58 PM
  5. Search Macro Needed
    By O0J0E in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-15-2012, 11:19 PM
  6. Replies: 0
    Last Post: 01-14-2012, 02:13 AM
  7. Macro to Search column and if found, copy a cell within the worksheet
    By SKooT1027 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-16-2008, 01:12 PM
  8. [SOLVED] when I search for data in Excel, the found cell cannot be seen
    By Howard in GR in forum Excel General
    Replies: 3
    Last Post: 07-21-2006, 04:55 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