HLOOKUP

  • Thread starter Thread starter Freshman
  • Start date Start date
F

Freshman

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.
 
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)
 
Thanks, Lorderon. How stupid I am of overlooking the number of rows. Thanks
once again. Regards.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top