Trying to do a group IF statment

grantw

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.

Paul Newcome

I am going to suggest setting everything up as a table in your master sheet and using a VLOOKUP function. 

J. Craig Williams

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