Ask Your Question

How to get the correct result with HLOOKUP? [solved]

asked 2019-06-10 02:58:56 +0100

cfe_teacher gravatar image

updated 2019-06-10 03:19:54 +0100


If I enter "cow" into the search criterion box, I get the answer "5". Why is this so when "cat", "dog" and "wolf" all get the correct answer.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-06-10 03:06:14 +0100

Because you omitted the last parameter (Sorted), in which case (or if it's not 0), the data is considered sorted.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-06-10 02:58:56 +0100

Seen: 50 times

Last updated: Jun 10 '19