Invalid hlookup result if range lookup true

182 Views Asked by At

I've problem with Microsoft Excel HLOOKUP function as below

Problem

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

Semangka

Is there something that I miss?

Thanks and regards,

1

There are 1 best solutions below

5
On

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

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

enter image description here