+ 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
    123

    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 2000/3/7/10/13/16
    Posts
    41,047

    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 some-1 helped you

    Regards
    Ford

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

    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
    123

    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 Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    11,630

    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 2000/3/7/10/13/16
    Posts
    41,047

    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)

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