Hi I am trying to figure out a formula for calculating the demand for a years worth of material being used in several different parts below is the Tables that should help. I think it should be a IF vlookup but I am still new to formulating using the fuctions for both. Please Help!! Thank you! This is a smaller example, The real data sheet is about 100 rows by 10 columns.