Contain, If, Index/Match formula to cross reference
GNg
✭✭
Hello
I have sheet 1 as a reference database as below:
Sheet 1:
And I would like to pull data from Sheet 1 to Sheet 2 only from customer CA.
Sheet 2:
Could you please help me to develop a formula as I have more than 10000 No. to cross reference? Also it would be better if I can use INDEX/MATCH formulas as I need to refer more than 100K cells.
Thanks a lot!
Answers
-
Have you looked into creating a report?
-
Hi Paul
I actually need to pull the notes from multiple sheets in accordance with the same "No." and the report is unable to cross them into the same row. Hence that's why I am trying to compile them using the sheet instead.
Thanks
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!