is my excel corrupt? VLOOKUP

[Vass]

I was having problems with a huge spreadsheet using VLOOKUP
so I tried a small simple table and I'm getting some strange results

can someone have a look here
http://www.naldernet.plus.com/holding/vlookup.xls
and explain why if you type "horn" at B14 does it return the result of B5 ?
thanks in advance

probably something really stupid I missed in the VLOOKUP formula

 

[Gordon]

I was having problems with a huge spreadsheet using VLOOKUP
so I tried a small simple table and I'm getting some strange results

can someone have a look here
http://www.naldernet.plus.com/holding/vlookup.xls
and explain why if you type "horn" at B14 does it return the result of B5 ?
thanks in advance

probably something really stupid I missed in the VLOOKUP formula

Add the parameter FALSE after 2.
So your formula is: VLOOKUP(B14,data,2,FALSE)
That then works.

 

[Roger Govier]

You need the 4th argument to VLOOKUP either 0 or FALSE as your data is not
sorted

=VLOOKUP(B14,data,2,0)