Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HLookup help
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hlookup help | Excel Discussion (Misc queries) | |||
HLOOKUP | Excel Worksheet Functions | |||
HLOOKUP and SUM | Excel Discussion (Misc queries) | |||
hlookup & ? | Excel Worksheet Functions | |||
hlookup | Excel Discussion (Misc queries) |