Link columes to another sheet, find end
Hey support,
I need your help. I have two sheets and I want to copy columes from one to another sheet.
The data in sheet 1 is updated automatically and the amount of rows varies. It varies from approx 1000 to 2000 rows.
In sheet 1 I added an automatic line ID.
In sheet 2 I created the line ID "manually" with a certain line (maximum).
With the formulas "=INDEX({Sheet1 Colume1}; MATCH(ZeilenID@row; {Sheet1 Bereich 1}))" I now copy the individual columns from sheet 1 to sheet 2. This also works.
My problem:
In sheet 1 there are only 6 rows. In sheet 2, however, data is displayed up to line 13, see picture.
Example:
In lines 7-13, the last entry from sheet 1 is always displayed.
My idea was to check the entry from colume1 is empty, but this doen´t work. It says "incorrect argument set"
=INDEX(IF(ISBLANK({Sheet1 Colume1}); "---"; {Sheet1 Colume1}); MATCH(ZeilenID@row; {Sheet1 Bereich 1}))
Do you have an idea how to solve the problem?
Regards
Christian
Answers
-
Hi Christian
Please try using the formula below
=IFERROR(INDEX({Sheet1 Colume1}, MATCH(ZeilenID@row, {Sheet1 Bereich 1}, 0)), "")
Best Regards
Amit Wadhwani, Smartsheet Community Champion
Smartsheet CoE, Ignatiuz, Inc., Exton, PA
Did this answer help you? Show some love by marking this answer as "Insightful 💡" or "Awesome ❤️" and "Vote Up ⬆️"https://www.linkedin.com/in/amitinddr/ -
Hey Amit,
thanks it works.
I forgot the "0" in MATCH 😣.
Regards
Christian
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!