Index/Match vs. Index/Collect?

I am trying to collect multiple information sources into one collective sheet. First is the hours. Once I get the hang of the formula needed I can write for the others.

Collection Sheet: The blank highlighted cell below is where I am trying to write the formula. I want the formula to return the facility hours from the "Hours Sheet" underneath this one.

I want to say, in January (match the 1's), Belton (highlighted) had 9,382.2168


Hours sheet:


Everything I am trying is giving me "unparseable" or "incorrect argument set". I've not done a multiple criteria formula and I'm finding myself a bit lost.

Also to note: I'm not sure if I needed to set up column 6 in the hours sheet with the "Month" formula. I did this because I have a copy/paste of each month going into the hours sheet, so "Belton" will show up in each copy/paste every month. The idea is to pull from the correct month by matching the month numbers. Again, not sure if this is necessary or not.


Please help, and thank you!!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!