+ Reply to Thread
Results 1 to 4 of 4

Test cell status & populate neighboring cell from list sequentially

  1. #1
    Registered User
    Join Date
    04-21-2020
    Location
    Downunder
    MS-Off Ver
    Latest
    Posts
    7

    Test cell status & populate neighboring cell from list sequentially

    Hello gurus .. wondering if this is possible ?

    Looking to populate a cell from a list by checking the data in a neighboring cell (aka flag). Where the match is true, a column exists additionally with a list that needs to be applied sequentially. Ie item 1 for the first match, then item 2 for the next match... and so on

    All the cell needs to do if check for a flag. If flag exists, populate the next item from the list. The list essentially could simply be a 3rd column.

    Columns:
    Flag,Data (dynamically applied)

    Additional column:
    List (the dynamic data to apply)


    Thanks

  2. #2
    Registered User
    Join Date
    04-21-2020
    Location
    Downunder
    MS-Off Ver
    Latest
    Posts
    7

    Re: Test cell status & populate neighboring cell from list sequentially

    Will post link with sample soon..

  3. #3
    Registered User
    Join Date
    04-21-2020
    Location
    Downunder
    MS-Off Ver
    Latest
    Posts
    7

    Re: Test cell status & populate neighboring cell from list sequentially

    Sample attached
    Attached Images Attached Images

  4. #4
    Registered User
    Join Date
    04-21-2020
    Location
    Downunder
    MS-Off Ver
    Latest
    Posts
    7

    Talking Re: Test cell status & populate neighboring cell from list sequentially

    Sorted it ..

+ 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 Cell Based on Searched Text from Neighboring Cell?
    By Smohrman in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-08-2017, 06:48 PM
  2. [SOLVED] Populate Name and Date for one status only from a list of different status
    By suchetherrah in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-30-2015, 07:31 AM
  3. Replies: 8
    Last Post: 10-28-2015, 10:22 AM
  4. Find empty cells and use data from neighboring cells to populate a list?
    By Margate in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-30-2015, 05:33 PM
  5. [SOLVED] Populate Text in Cell based on blank/non-blank status of other cell(s)
    By cmkarnes in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-24-2015, 06:53 AM
  6. Replies: 3
    Last Post: 04-04-2014, 11:34 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