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

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.

1 Answer

Sort by » oldest newest most voted

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

1 follower

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

Seen: 50 times

Last updated: Jun 10 '19