Having some trouble with getting the right formula to reference a cell across multiple sheets. My starting point is B4 in what we'll call Sheet 1. I want to pull from Cell B4 in Sheet 2, and increase from there in intervals of 3 (Sheet 1 B5=Sheet 2 B7, Sheet 1 B6= Sheet 2 B10, Sheet 1 B7 = Sheet 2 B13, etc).
Currently, I'm getting an error with this:
=INDIRECT(IF(ISBLANK(Scores!(((COLUMN()-4)*3)+4)&2),"",IF(Scores!(((COLUMN()-4)*3)+4)&2>(((COLUMN()-4)*3)+5)&2,"W","L")))
??
Bookmarks