+ Reply to Thread
Results 1 to 3 of 3

Populating two rows when a specific value is entered into a cell

  1. #1
    Registered User
    Join Date
    11-26-2018
    Location
    London, UK
    MS-Off Ver
    Office 2010
    Posts
    16

    Populating two rows when a specific value is entered into a cell

    Hello,

    I wonder if any can guide me.

    I have a vlookup formulas in sheet 1 which relate to data in sheet 2.
    When a particular code number is typed in a cell in sheet 1 it populates some cells with information from sheet 2 using a vlookup.


    However for some code numbers I need a second row to be added. So I would like when a particular value is typed for a second row to be added (which will contain the same data as the first entry; except for one cell; but don't worry about that for now).


    My question is; does anyone know if what I want is possible ? And if so can anyone offer some advice on how I can complete this.


    Thanks to everyone that considers this post.


    El.

  2. #2
    Valued Forum Contributor than_gold's Avatar
    Join Date
    10-17-2017
    Location
    Coimbatore India
    MS-Off Ver
    Office 365
    Posts
    517

    Re: Populating two rows when a specific value is entered into a cell

    You could try with Index+Match,
    Pls attach the sample excel sheet for assist you in better way.
    Regards,
    Thangavel D

    Appreciate the help? CLICK *

  3. #3
    Registered User
    Join Date
    11-26-2018
    Location
    London, UK
    MS-Off Ver
    Office 2010
    Posts
    16

    Re: Populating two rows when a specific value is entered into a cell

    Thanks for you response, I am not in a position to attached anything at the moment. But I will attached something later this evening. Thank you.

+ 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