+ Reply to Thread
Results 1 to 6 of 6

Fill In Value in Column with IF

  1. #1
    Forum Contributor
    Join Date
    07-12-2010
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    136

    Fill In Value in Column with IF

    Hello. This is one of the situations where it is best to see the sample.
    My website generates a CSV file. I need to manually create a column and fill it in with the values.
    So in the example attached you will see column E is highlighted. This is the value i need to show.
    I was thinking of working with the C column. If C has a value that is not 0 copy the SKU in column E that is equal to the value in C
    Make sense lol?
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Fill In Value in Column with IF

    Perhaps this, copied down...
    =IF(C2>0,D2,"")
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Contributor
    Join Date
    07-12-2010
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    136

    Re: Fill In Value in Column with IF

    Quote Originally Posted by FDibbins View Post
    Perhaps this, copied down...
    =IF(C2>0,D2,"")
    Sorry that doesn't work, that should be getting the numbers starting with a P.

  4. #4
    Forum Contributor
    Join Date
    07-12-2010
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    136

    Re: Fill In Value in Column with IF

    I am almost there.... but stuck
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    This doesn't copy for the other rows I need the same number for.... I am probably approaching it the wrong way. Anyone point me in the right direction?
    Last edited by ryanb4614; 01-11-2017 at 02:54 PM.

  5. #5
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Fill In Value in Column with IF

    Try the attached code.
    Attached Files Attached Files

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Fill In Value in Column with IF

    This works for when the ID and SKU match, but how would you see that a non=matching SKU belongs with a certain ID?
    =IFERROR(IF(ISNUMBER(D2),INDEX($D$2:$D$30,MATCH("*"&D2,$D$2:$D$30,0)),""),"")
    copied down

+ 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] Fill in a column by a number column OR stretch a column
    By whatever61 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-05-2015, 10:17 PM
  2. [SOLVED] fill column and no fill column macro
    By Alastair77 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-10-2014, 12:23 PM
  3. Fill cells in one column based on specific words or letter from another column
    By dokkadokka in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-21-2013, 07:04 AM
  4. Insert column and fill column upto where data is in previous column
    By aka189 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-24-2012, 06:07 AM
  5. [SOLVED] If column A has gray fill and column B has no fill, delete that row
    By killhuman in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-11-2012, 05:36 PM
  6. Replies: 0
    Last Post: 08-10-2012, 12:55 PM
  7. Replies: 1
    Last Post: 09-07-2011, 05:57 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