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 |
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) |