Hello, I am attempting to alter an excel document that I use at work. The document has a large list of parts and materials that may need to be used for any one job. Quite often, less than half on the materials and parts are required so I would like to have a separate sheet which only lists the items with quantities without needing to go in and alter the formula every time a job requires different materials. I have tried massive (=IF) functions with no luck. I am not sure how to proceed but any help is greatly appreciated.