+ Reply to Thread
Results 1 to 4 of 4

Searching for numbers in one workbook & marking the number in another workbook.

  1. #1
    Registered User
    Join Date
    09-15-2014
    Location
    Denmark
    MS-Off Ver
    Office 2010/2007
    Posts
    2

    Searching for numbers in one workbook & marking the number in another workbook.

    woorkbookA.xlsm

    and

    woorkbookB.xlsm

    The contents/number in column J of woorkbookA has to be checked with column S of woorkbookB.
    If the contents/number in column J exists in column S of woorkbookB, I want it to be marked with an X in column U of workbookB.

    I've been trying to get this to work, I've gotten some help from others but I'm stuck with this piece of code:

    =IF(ISERROR(MATCH(S2;[woorkbookA.xlsm]Blad1!$J$1:$J$13;0));"";"x")

    But I keep getting #NAME? errors when putting in the formula in U2.
    I've been told it could be regional differences since I use Swedish settings.

    I appreciate any help! I'm quite the newbie with excel.

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Searching for numbers in one workbook & marking the number in another workbook.

    Ive just done it with your formula, and it works.
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

  3. #3
    Registered User
    Join Date
    09-15-2014
    Location
    Denmark
    MS-Off Ver
    Office 2010/2007
    Posts
    2

    Re: Searching for numbers in one workbook & marking the number in another workbook.

    It does?
    Could you tell me how you did it? I feel really stupid now...
    Step-by-step, how did you do it?

    EDIT:

    I've usually done it by just putting the code into a cell as a formula, with the f(x) above the grids.
    Last edited by aadamuka; 09-15-2014 at 08:28 AM.

  4. #4
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Searching for numbers in one workbook & marking the number in another workbook.

    I copied your formula, and changed the ;'s for ,'s as in the UK, and it worked.

    =IF(ISERROR(MATCH(S2,[woorkbookA.xlsm]Blad1!$J$1:$J$13,0)),"","x")

  5. #5
    Registered User
    Join Date
    09-15-2014
    Location
    Denmark
    MS-Off Ver
    Office 2010/2007
    Posts
    2

    Re: Searching for numbers in one workbook & marking the number in another workbook.

    Yay! It does work. However, my next problem:

    It did work in my examples, woorkbookA and workbookB.
    I want to use this code in the two documents I need to use it in, they're called KAPPREDDD(workbookA) and SEM KUND KAP(workbookB).
    I figured that if I change the code:

    =IF(ISERROR(MATCH(S2,[woorkbookA.xlsm]Blad1!$J$1:$J$13,0)),"","x")

    to:

    =IF(ISERROR(MATCH(S2,[KAPPREDD.xlsm]Blad1!$J$1:$J$13,0)),"","x")

    It would work the same? But now the cell is filled with a blank space, when it should be marked an X.

    Could it have to do with the "Blad1!$J$1:$J$13,0" part of the code? How would I change it to fit my needs?

+ 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] Want auto-gen number in template workbook to stop working when saved to normal workbook
    By tjamestx in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-24-2014, 02:56 PM
  2. Replies: 4
    Last Post: 12-01-2013, 03:22 AM
  3. searching & marking the parallel rows
    By ammy.rocks in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-24-2013, 02:51 AM
  4. searching for specific data in one workbook and copies it to a 2nd workbook
    By baltazar in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-21-2012, 02:03 PM
  5. [SOLVED] workbook searching
    By Juuljus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-02-2005, 12:00 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