splitting sheet into two - need help
Hi, I reached max capacity with a sheet and now need to split it into two - however, we were copying data from our "advertisements" into the application rows - now all applications will be on a separate sheet, however, I still need to include information from each ad into each applicant's row - for example, each ad has a classification - we don't require the applicant to fill out the classification they are applying for as we have this with the ad - both app and the ad have the same "primary number" field TEMP # - is there a formula that can compare the TEMP # on one sheet with the ad to the sheet with the application and pull in the information that is missing from the app (?) ie., classification.
Thank you for your help!
Help Article Resources
Check out the Formula Handbook template!