jmh2008
New Member
- Joined
- Sep 4, 2009
- Messages
- 42
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?