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.

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