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.