I've been working on a formula to extract data from the master sheet on excel to sub sheets. I've got
the formula to work but when I enter new teams on the master sheet, it's not extracting to the sub sheets properly. it creates a #number error. What am I doing wrong? Please look on the tyke.novice tab to see the problem i'm commenting on.