Assign column values to heading? - Linking Cell Movement
Results 1 to 4 of 4

Thread: Assign column values to heading? - Linking Cell Movement
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jun 2019
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Assign column values to heading? - Linking Cell Movement

    Hi!

    I want to be able to make cells move together if I change the value of one of the headings. I currently have the heading set up to come from another sheet using a vlookup. When I insert a column on the other sheet, (say, Jim) the second table below is what I get, but what I want to occur is the third table below.
    Jeff Mark Phil
    Height 194 175 166
    Weight 81 76 60
    Jeff Jim Mark Phil
    Height 194 175 166
    Weight 81 76 60
    Jess Jim Mark Phil
    Height 194 175 166
    Weight 81 76 60

    Any help would be much appreciated

    Thanks

  2. #2
    Board Regular
    Join Date
    Oct 2009
    Location
    Midlands, UK
    Posts
    7,489
    Post Thanks / Like
    Mentioned
    17 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Assign column values to heading? - Linking Cell Movement

    Something like in B2 of your new sheet. Copy across and down as required:

    =IFERROR(INDEX(Sheet1!$B$2:$D$3,MATCH($A2,Sheet1!$A$2:$A$3,0),MATCH(B$1,Sheet1!$B$1:$D$1,0)),"")

    With the primary table in Sheet1!A1:E3

  3. #3
    New Member
    Join Date
    Jun 2019
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Re: Assign column values to heading? - Linking Cell Movement

    The primary table is more like below

    Name City Level
    Jeff Perth 5
    Mark London 2
    Phil New York 4

    And these Names become the heading of the table in the original post with the formula:
    =IFERROR(VLOOKUP(COLUMN()-2,'Sheet1'!$C$5:$F$50,ROW(),0), "")
    and dragged across.

    So then what I'm trying to achieve is if I add a row to this table,


    Name City Level
    Jeff Perth 5
    Jim
    Mark London 2
    Phil New York 4

    The second table (in the original post), will react as in the third table in the original post, whereas what occurs now is in the second table.

    Will your solution still work in this context? Sorry I should have gone into more detail initially

    Thanks a bunch!

  4. #4
    New Member
    Join Date
    Jun 2019
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Assign column values to heading? - Linking Cell Movement

    Be better frame and contextualize this questions:
    Hi,
    I have data in a primary table structured like below:

    Name City Level
    Jeff Perth 5
    Mark London 2
    Phil New York 4



    The names in which, are being input into another sheet using a vlookup, as below:


    Jeff Mark Phil
    Height 194 175 166
    Weight 81 76 60


    With the following formula: =IFERROR(VLOOKUP(COLUMN()-2,'Sheet1'!$C$5:$F$50,ROW(),0), "")
    dragged across, accounting for small formatting deviations.

    What I'm trying to achieve, is if I add a row to my first table, as below:


    Name City Level
    Jeff Perth 5
    Jim
    Mark London 2
    Phil New York 4


    The second table, will react like below:


    Jeff Jim Mark Phil
    Height 194 175 166
    Weight 81 76 60


    Instead of what I'm currently getting below:


    Jeff Jim Mark Phil
    Height 194 175 166
    Weight 81 76 60



    So, essentially, I want the data below the heading in the second sheet, to move along with the heading if a new Name is added on the first sheet.

    Sorry if this is a little confusing to follow

    Thanks

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •