+ Reply to Thread
Results 1 to 8 of 8

Having problem while filling data from a sheet into another.

  1. #1
    Registered User
    Join Date
    02-02-2018
    Location
    TURKEY
    MS-Off Ver
    2019
    Posts
    52

    Having problem while filling data from a sheet into another.

    Hello everyone,

    So I'm trying to fill data to sheet "PROD BILKON" from the sheet "check" using the SUMPRODUCT function when ORDER NO and COLOR is matching, the thing is that I'm having the value 0 when I apply the function I did it with the Column CUTTING and I'm going to apply the same function to the other columns.

    Note: all the fields in the sheet "check" are in TEXT format cell, I had to change all of them and do it like that because I export this sheet "check" from a tracking system otherwise I have different values.

    would you please help me with it if you can?

    Thank you.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    13,115

    Re: Having problem while filling data from a sheet into another.

    If you are simply trying to return the text date, try
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    This is an array formula & needs to be confirmed with Ctrl Shift Enter

  3. #3
    Registered User
    Join Date
    02-02-2018
    Location
    TURKEY
    MS-Off Ver
    2019
    Posts
    52

    Re: Having problem while filling data from a sheet into another.

    I tried it, but unfortunately, I got an empty cell which means I had an error when I have the IFERROR out I got #N/A error.
    Last edited by AliGW; 06-16-2019 at 01:35 PM. Reason: Please don't quote unnecessarily!

  4. #4
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,090

    Re: Having problem while filling data from a sheet into another.

    Not sure why you use Sumproduct for Text.

    Maybe try at PROD BILKON J2
    =LOOKUP(1,1/(check!$B$2:$B$505=$D2)/(check!$C$2:$C$505=$E2),check!E$2:E$505)

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    13,115

    Re: Having problem while filling data from a sheet into another.

    Did you confirm the formula with Ctrl Shift Enter rather than just enter?
    If so you in the formula bar you should see the formula wrapped in {}

  6. #6
    Registered User
    Join Date
    02-02-2018
    Location
    TURKEY
    MS-Off Ver
    2019
    Posts
    52

    Re: Having problem while filling data from a sheet into another.

    I'm so sorry I didn't see the line below the function box, I confirmed it. it works thank you.

  7. #7
    Registered User
    Join Date
    02-02-2018
    Location
    TURKEY
    MS-Off Ver
    2019
    Posts
    52

    Re: Having problem while filling data from a sheet into another.

    Perfectly worked, Thank you very much.

  8. #8
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    13,115

    Re: Having problem while filling data from a sheet into another.

    You're welcome & thanks for the feedback

+ 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. Filling in sheet 1 empty data from sheet 2
    By GurungBoi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-29-2016, 05:10 PM
  2. Data automatically filling to another sheet?
    By housendahouse in forum Excel General
    Replies: 4
    Last Post: 12-09-2013, 01:51 PM
  3. [SOLVED] Searching for sheet, counting and filling in data
    By knutfh in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-05-2013, 09:57 AM
  4. Problem Auto filling from one sheet to another
    By skypilotpete in forum Excel General
    Replies: 0
    Last Post: 09-14-2012, 10:57 PM
  5. Problem filling the data
    By strippy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-26-2012, 09:54 AM
  6. Sheet Selection and Data Filling
    By SunOffice in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-16-2011, 10:03 PM
  7. Filling empty cells with the right data from another sheet
    By sentinela in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-26-2009, 05:56 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