View attachment example excel book.xlsx
I am trying to use a drop-down cell to pull from multiple criteria. I tried to color-code the cells to help explain.
I want to be able to read information on the main sheet from the # stores sheet. I'm not sure if the list sheet will be involved in anything other than the data validation for the yellow location drop-down box.
I feel like this is a sumifs formula, but I can't figure out how to make it work! Please help! :Cry:
I am trying to use a drop-down cell to pull from multiple criteria. I tried to color-code the cells to help explain.
I want to be able to read information on the main sheet from the # stores sheet. I'm not sure if the list sheet will be involved in anything other than the data validation for the yellow location drop-down box.
I feel like this is a sumifs formula, but I can't figure out how to make it work! Please help! :Cry: