Index Match returning wrong values

[CoachK88]

Hi all,

I am creating a database where one sheet of the workbook is strictly for entering basic data ("Data Entry" sheet), which is pulled and and populates to a second sheet for generating some deeper calculations ("Calculations" sheet). The reason for doing this is that I am only entering data for some days, not all, and the calculations sheet is set up to automatically generate 0 values for days that aren't actually entered in the Data Entry sheet. For some reason, the calculations cells, specifically in the F column on the Calculations sheet are pulling back the wrong values, and some of the columns in the I column on the Calculations sheet are generating 0's where there should be data. Example 1 being the person in cell C6 should return a value in F6 of 480, yet is only returning 360. Example 2 being the person in cell C17 returning a 0 value in I17 where it should yield a value of 420. It seems values from the table are being pulled, but are not pulling to the corresponding line in the calculations tab. Any insights?

[scottiex]

your data entry has no entry for Rowley on the 2nd

you match the name and the date and multiply them but if you chose the 5th name and the date starting on the 20th line that gives you the 100th item not the 25th. I'd suggest you use addition instead however...

really your method of index match isn't a robust way to do this since what if you have an extra person one day? or one less entry?

You probably want to create a hidden column and concatenate date and athlete then do all your index match based on that.