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