Hi,
Yesterday I posted a similar question to this one but figured more context is needed in order for a solution to work for me
For context, I have data in a primary table structured like below:
<tbody>
</tbody>
The names in which, are being input into another sheet using a vlookup, as below:
<tbody>
</tbody>
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:
<tbody>
</tbody>
The second table, will react like below:
<tbody>
</tbody>
Instead of what I'm currently getting below:
<tbody>
</tbody>
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
Yesterday I posted a similar question to this one but figured more context is needed in order for a solution to work for me
For context, I have data in a primary table structured like below:
Name | City | Level |
Jeff | Perth | 5 |
Mark | London | 2 |
Phil | New York | 4 |
<tbody>
</tbody>
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 |
<tbody>
</tbody>
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 |
<tbody>
</tbody>
The second table, will react like below:
Jeff | Jim | Mark | Phil | |
Height | 194 | 175 | 166 | |
Weight | 81 | 76 | 60 |
<tbody>
</tbody>
Instead of what I'm currently getting below:
Jeff | Jim | Mark | Phil | |
Height | 194 | 175 | 166 | |
Weight | 81 | 76 | 60 |
<tbody>
</tbody>
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