Invalid hlookup result if range lookup true

Question

I've problem with Microsoft Excel HLOOKUP function as below

As you can see, the result is #N/A for function that set true as lookup range

Where I'm expecting is should be 25 since it should find Mangga correctly (Like when it's false)

But searching Semangka would be as expected

Is there something that I miss?

Thanks and regards,

Answer 1

While HLOOKUP() will work with Exact_Match you can also use INDEX/MATCH like-

=INDEX(A2:E5,2,MATCH(A7,A1:E1,0))