Ask Your Question
0

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

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

cfe_teacher gravatar image

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

C:\fakepath\hlookup.ods

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
1

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

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

Stats

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

Seen: 22 times

Last updated: Jun 10