| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HLOOKUP
Dear experts,
In sheet "Team", cell N3 is a lookup value. In sheet "Group", array table is E9:L42 and row index is 42. So, in sheet "Team" cell N4, I set a formula to lookup value in sheet "Group" as follows: =HLOOKUP(N3,'Team'!E9:L42,42,False) However, the result of a return is #Ref!. Please advise what's the problem and how to fix it. Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help with hlookup | Excel Discussion (Misc queries) | |||
| Hlookup | New Users to Excel | |||
| hlookup & ? | Excel Worksheet Functions | |||
| Hlookup/max value? | Excel Worksheet Functions | |||
| HLookup ??? | Excel Discussion (Misc queries) | |||
Threaded Mode
