Try =HLOOKUP($A$5,'Data Entry'!$C$4:$M$472,(ROW()-5)*9+2,FALSE)