I selected cell B2 on sheet 2 and typed exactly as you specified above into the formula bar.
=IF(ISNA(MATCH(B$1,OFFSET(Sheet1!$A$1,MATCH($A2,User,0),1,COUNTIF(User,$A2),1),0)),"",MATCH(B$1,OFFSET($H$1,MATCH($A2,User,0),1,COUNTIF(User,$A2),1),0))
Excel error: The formula you typed contains an...