+ Reply to Thread
Results 1 to 2 of 2

Searching against multiple fields in a single row, populate new field in same row

  1. #1
    Registered User
    Join Date
    04-06-2016
    Location
    Oklahoma City, Oklahoma
    MS-Off Ver
    2016
    Posts
    29

    Question Searching against multiple fields in a single row, populate new field in same row

    This is part 2 of my question about searching, matching for a particular value, and then populating a cell based on certain conditions. . . .

    In this scenario, Column A will always be either a 1 or a 2.
    Column B is an originating value
    Column C is a terminating value

    If A2 equals "1", populate D2 with B2, but if A2 equals "2", then populate D2 with C2
    If A3 equals "1", populate D3 with B3, but if A3 equals "2", then populate D3 with C3
    If A4 equals "1", populate D4 with B4, but if A4 equals "2", then populate D4 with C4

    This problem exists in the same spreadsheet as my previous post. I'd like to run a formula on the spreadsheet to solve the first part, delete the rows with a value of False, and then run THIS formula against the remaining rows of data.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,146

    Re: Searching against multiple fields in a single row, populate new field in same row

    Try

    =IF(A2=1,B2,C2)
    Last edited by JohnTopley; 04-06-2016 at 04:44 PM.

+ 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. Replies: 5
    Last Post: 04-06-2016, 04:55 PM
  2. Formula to create multiple address fields using data in single field
    By MrHo1956 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-02-2015, 11:41 AM
  3. [SOLVED] Populate Field From Single Data Validation Selection
    By warrior2411 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-05-2013, 09:04 PM
  4. MACRO needed to auto populate fields if an X is placed in a specific field
    By dbasch89 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-31-2012, 04:03 PM
  5. Replies: 2
    Last Post: 02-27-2012, 09:16 PM
  6. Replies: 17
    Last Post: 02-24-2012, 03:59 PM
  7. Replies: 3
    Last Post: 08-11-2009, 09:45 AM

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