Using Index/Match to pull in data

Options

Hello. I am trying to set up Index/Match to pull in Data from another sheet. I eventually would like to pull the same columns from 3-4 different sheets to combine them into a sort of "master sheet" for these values that I can run reports on. Here is the sheet with the data,

And here is the "master" sheet I am trying to set up with Index, but getting No Match on.

I am trying to reference/search by the date column since this will be viewed as an 'across the company by day" way in the master reports. I tried following some instructions in other posts as far as setting up cross sheet references and using those in formulas, but seem to be stuck. Any help is appreciated

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!