If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
HLOOKUP
Hi,
Your row index (42) is not correct, because row index count is from row 9 (starting point, so this will be row index 1) to row 42 (your end point, so this will be row index 34). So basically the correct row index should be 34. =HLOOKUP(N3,'Team'!E9:L42,34,False) "Freshman" wrote: 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. |
#3
|
|||
|
|||
HLOOKUP
Thanks, Lorderon. How stupid I am of overlooking the number of rows. Thanks
once again. Regards. "Lorderon" wrote: Hi, Your row index (42) is not correct, because row index count is from row 9 (starting point, so this will be row index 1) to row 42 (your end point, so this will be row index 34). So basically the correct row index should be 34. =HLOOKUP(N3,'Team'!E9:L42,34,False) "Freshman" wrote: 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 | |
Display Modes | |
|
|