vlookup not functioning properly

[TXkleen]

Howdy folks,

I have a spreadsheet in which I have a column of cells that all contain 7 characters. I am extracting characters 4, 5, and 6 of these cells via this formula:

Cell H3: =VALUE(MID(G3,4,3))

I am then using the following vlookup trying to pair the data in H3 with a lookup table on my 2nd tab:
=VLOOKUP(I3,lookups1!$A$3:$B$9,2)

The lookup table is as follows:


A B
3 016 0w16
4 020 0w20
5 520 5w20
6 530 5w30
7 540 5w40
8 103 10w30
9 154 15w40

The lookup seems to work until it tries to query "103." When this happens, it yields "0w20" but it should yield "10w30"

I have tried converting the 3 character extraction to value, text, etc., as well as converting the lookup cells to values, text, etc., and nothing seems to fix the glitch.

Any ideas?

Thanks

 

[TXkleen]

typo above. the vlookup string is =VLOOKUP(H3,lookups1!$A$3:$B$9,2)

 

[barry houdini]

You would usually have FALSE as 4th argument, i.e.

=VLOOKUP(H3,lookups1!$A$3:$B$9,2,FALSE)