+ Reply to Thread
Results 1 to 7 of 7

Insert specific value according to preceding cell value.

  1. #1
    Registered User
    Join Date
    01-25-2015
    Location
    Seattle
    MS-Off Ver
    2013
    Posts
    6

    Insert specific value according to preceding cell value.

    Here is a small excerpt from a large spreadsheet (see #1 below). Many values in column 1 of this spreadsheet are (83520-9) and (74843-2). I'd like to populate the cells directly to the right of the cells with value (83520-9) with value (Permethrin .52%). I want it to look like (#2 below)


    #1

    83520-9 1/5/2015
    33906-10 1/6/2015
    74843-2 1/6/2015
    74843-2 1/6/2015
    74843-2 1/6/2015

    #2

    83520-9 Permethrin .52% 1/5/2015
    83520-9 Permethrin .52% 1/5/2015
    33906-10 1/6/2015
    74843-2 1/6/2015
    74843-2 1/6/2015
    74843-2 1/6/2015


    Thanks much

    Gianpaolo

  2. #2
    Registered User
    Join Date
    02-25-2014
    Location
    Brisbane
    MS-Off Ver
    Excel 2000
    Posts
    78

    Re: Insert specific value according to preceding cell value.

    =IF(A1="83520-9","Permethrin .52%","")

    But for this to work it would need it's own column between the 83520-9 and the date?

  3. #3
    Registered User
    Join Date
    01-25-2015
    Location
    Seattle
    MS-Off Ver
    2013
    Posts
    6

    Re: Insert specific value according to preceding cell value.

    Got it, thanks Shannon. I see how this IF statement works. There are many other 83520-9 Column A entries within the spreadsheet. Is it possible to apply this IF formula with out manually having to paste it into cells in Column B or apply it to all cell in Column B? I have numerous other duplicate column A values with corresponding Column B values.

  4. #4
    Registered User
    Join Date
    02-25-2014
    Location
    Brisbane
    MS-Off Ver
    Excel 2000
    Posts
    78

    Re: Insert specific value according to preceding cell value.

    Sorry I need a little bit more clarification.

    Are you able to attach an example spreadsheet to show how it looks and what you want it to look like?

    From what I can understand, what you want is for the formula to look at a range of data and then add the text next to the matching code, without adding any other columns. Is that correct?

  5. #5
    Registered User
    Join Date
    02-25-2014
    Location
    Brisbane
    MS-Off Ver
    Excel 2000
    Posts
    78

    Re: Insert specific value according to preceding cell value.

    This might sound silly and I am not sure it is exactly what you need, but why don't you record a macro that selects all the data and using the Find and Replace function find all 83520-9 and replace it with 83520-9 Permethrin .52%.

    Find and Replace.JPG

  6. #6
    Registered User
    Join Date
    01-25-2015
    Location
    Seattle
    MS-Off Ver
    2013
    Posts
    6

    Re: Insert specific value according to preceding cell value.

    I've attached the excel spreadsheet. I used you formula in cells B7, B8 and B9.

    Thank you much
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    02-25-2014
    Location
    Brisbane
    MS-Off Ver
    Excel 2000
    Posts
    78

    Re: Insert specific value according to preceding cell value.

    This will require VBA code that can look at multiple Criteria.

    Unfortunately My VBA coding skills are still very basic and I can only get it to look at 1 Criteria not 2.

    I'm sorry, you may want to move this post to the VBA section.

    Sorry I couldn't be more helpful.

+ 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] Formula to insert text in new column if preceding more than one of the preceding have val
    By aimeecrystalaid in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-04-2013, 11:47 PM
  2. Replies: 3
    Last Post: 07-12-2013, 09:17 AM
  3. Replies: 6
    Last Post: 04-08-2013, 05:12 PM
  4. Replies: 3
    Last Post: 02-01-2012, 04:21 PM
  5. How do I insert preceding zeroes?
    By Wrkoutguy08 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 03-05-2008, 02:05 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