Consulting

Results 1 to 4 of 4

Thread: FIND AND INSERT SI NO

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1

    FIND AND INSERT SI NO

    This file contain a wbook with 2 sheet.

    My problem is to find, during the import file REGIONE.EPF in the module1, from the column H of the sheet REGIONE_GOT in the sheet REGIONE_DISK column A, and if the value is not finded insert "NO" in the column M of the sheet REGIONE_DISK , if the value is finded insert "SI" in the column M of the sheet REGIONE_DISK...

    I have inserted in the column M of REGIONE_DISK a simple vlookup and the value not finded are colorized in RED

  2. #2
    Site Admin
    Jedi Master
    VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,712
    Location
    For M3:

    =IF(ISNA(VLOOKUP(A3,REGIONE_GOT!$H$3:$H$304,1,0)),"No","SI")
    Then fill down.

  3. #3
    Quote Originally Posted by DRJ
    For M3:

    =IF(ISNA(VLOOKUP(A3,REGIONE_GOT!$H$3:$H$304,1,0)),"No","SI")
    Then fill down.
    Tks Jacob , yes i know this metod but my problem is to insert the value during the import and in VBA...

  4. #4
    Site Admin
    Jedi Master
    VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,712
    Location
    You can put the formula in as you import the data:

    Range("M3").Value = "=IF(ISNA(VLOOKUP(A3,REGIONE_GOT!$H$3:$H$304,1,0)), "No","SI")"
    You can use variables for the rows as well.

Posting Permissions

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