=INDEX(Table!$1:$65536,MATCH('Dept Data'!$B8&"POS"&'Dept Data'!$C$7,Table!$E:$E,0),MATCH('Dept Data'!C$4&'Dept Data'!C$5&'Dept Data'!C$6,Table!$13:$13,0))
This equation is based on various things. I have Departments with more than one POS's and I have it lookup up to 4. But having these lookups for smaller departments ( 1 - 3 POS) has created the #N/A issue. Ideally I would like a 0 to appear because the department has a roll up feature. My image files are too large to be posted...
Essentially, the index is trying to pull data that isn't there, and returning #n/a, when I would like it to return 0. Should I fix this, or find a way to get my Roll up section (C11+R11+AB11+AV11 ect.) to exclude #n/a's. Which would be easier?
Bookmarks