I have a large table that feeds from Access so when access is updated this table is updated as well. I use this data to feed other worksheets in excel. So what I am working with is multiple columns and I want to create a formula that looks up specific data from only certain named columns. For example, I want to pull all amounts in the amount column ("AMT") Based on the whatever month I want to use in the Month column ("MON") based on what ever Fiscal Year it is in the Fiscal Year column ("FY"), based on the specific Unit that I want to pull the data for in the Unit column ("Unit") and based on the criteria I set in the status column ("STAT") which would be either BGT, EXP, PROJ. I was thinking a sumproduct formula would work but I can't figure out how to get it put in correctly.