I am by no means a power user, but I have managed to muddle through and find an INDEX,MATCH formula which comes close to doing what I want. What I have is several worksheets(sheet 1, sheet 3, sheet 4 etc.) that are all the same but I need to return information from 3 columns(which on my example file I have only inputted info to for simplicity) into a master worksheet (sheet 2). On sheet 2, I have the date and then I have a row of products. I want to return the amount of each product used under the correct product heading by date in order. My formula returns it under the correct product but not in order of date. I also need it to return a '0' (zero) or blank (no error or #REF) if there is no amount entered for a nonused product, because worksheet 2 totals everything. For bonus, if it can search by product number only instead of the whole name and number that would keep inputs simpler.
Right now I have one formula to return the date to sheet 2 and a separate formula to find the right column to return the amount into. Sheet 1 and the others are just input tables, sheet 2 is the formula (master) sheet that totals the inputs from the other sheets.