Hello everyone,

I'm working with a spreadsheet where...
B1=AVERAGE(I2:I11)

E1=large(Gas!A:A,1)

F1=INDEX(Gas!$A:$H,MATCH($E2,Gas!$A:$A,0))

F1:M11 is populated using the formula from F1 above.
I have one copy of this spreadsheet where B1 returns me the average from I2:I11 perfectly as I would expect it too. However, in an exact copy of this spreadsheet (copy and paste), the formula returns #DIV/0.

Any suggestions?

Thank you,