When values deleted, all calculation and info gone.

[jmh2008]

I created a spreadsheet for archery scores. I added some dummy data, had things running, great.So I decided to start fresh. I cleaned on the Input cells, and when i go and add data back in, nothing calculates.Auto Calculate is on. I open other spreadsheets and they work. below are some of the functions. I also have conditional formatting on the go. No macros.=IFERROR(INDEX($S$6:$V$34,MATCH(W6,$V$6:$V$34,0),1),"") =IFERROR(INDEX($T:$T,MATCH($W6,$V:$V,0)),"") =IFERROR(INDEX($F$6:$F$34,MATCH(W6,$V$6:$V$34,0)),"") =IFERROR(INDEX($D:$D,MATCH($W6,$V:$V,0)),"") =IFERROR(INDEX($E:$E,MATCH($W6,$V:$V,0)),"")Please help!! Soon, this is due for the weekend.How do I upload the spreadsheet?

 

[mole999]

there is no reason that cleaning cells without formulas will delete cells with formulas, use your most recent backup or rebuild the missing bits