HLookup help

[Txlonghorn76]

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

 

[Sheeloo]

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

Did you miss the ' before Spreadsheet Name

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

2. This may be because of blanks in your data.
Use =ISNA(HLOOKUP(D1,'Speardsheet
Name'!A$1:$AF$56,2,FALSE),"",HLOOKUP(D1,'Speardsheet
Name'!A$1:$AF$56,2,FALSE))
Use