I need help with the error I am getting. I have 2 spreadhseets and need the
dashbaord to pull from the data sheet using an HLookup. What I am using now
is giving me an #NA error:

=HLOOKUP(D1,Speardsheet Name'!A$1:$AF$56,2,FALSE)

d1=date to lookup
2=row number on array

Dashboard:
1-Sep 2-Sep 3-Sep 4-Sep
Person 1

Data Sheet:
1-Sep 2-Sep 3-Sep 4-Sep
Person 1 1 6
Person 2