Hlookup returns wrong field

[Alphacsulb]

Hello Guys,

This spreedsheet is driving me nuts. Here is my problem:

Row eleven starting at G uses this formula:
=HLOOKUP(I10,$G$3:$AB$4,2)

Pretty much what the formula says, or atleast hope it says is "Look at cell I10, if the figure in I10 matches a cell in the array G3 through AB4 then put down the figure that is below the matching one.

Row 12 is a simple if two cells match then True, if not False.

Anyways, as you can see from the picture I have the same formula in row 11, cells G11 and H11 match but I11 does not. It has the same word as I3 but is pulling the information as if it was matching to the cell in G3.

Help!!!!

[Alphacsulb]

here is the file.

I am stumped.

[Bob Phillips]

It needs to be ordered if range_lookup is TRUE. You could try

=HLOOKUP(G10,$G$3:$AB$4,2,FALSE)

which assumes you will always match.

[mdmackillop]

If Data is not ascending, use "False" to get exact match
=HLOOKUP(G10,$G$3:$AB$4,2,FALSE)

[Alphacsulb]

That's it guy. Hugs and kisses!

[Aussiebear]

Now there's some encouragement to learn VBA....