Trying to do a group IF statment

Not sure how to ask this but I am trying to set up a tracking sheet that will automatically pull info from a master sheet. I would like to send out a form from for someone to fill out and all they would need to do is put in the job # into the form, and on the track sheet it will automatically fill in the rest of the project info from the master projects sheet; Names, address, phone numbers etc. There could be hundreds of job number and address, so I am trying to find the best way to do this.
Comments
-
I am going to suggest setting everything up as a table in your master sheet and using a VLOOKUP function.
-
Be aware of the 25000 cell reference limit (so 10 columns of 2501 rows would be too many). This the limit on all incoming referenced cells to a sheet.
Craig
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!