HLookup help
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,'Speardshe et
Name'!A$1:$AF$56,2,FALSE))
Use
"Txlonghorn76" wrote:
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
|