is my excel corrupt? VLOOKUP

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
--
Vass

"Vass" <mark.nalder_TRAPTHESPAM_@btinternet.com> wrote in message
news:EuqdnTraeqlpM3XfRVnyuw@eclipse.net.uk...
> 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
> --
> Vass
>
>

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

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

=VLOOKUP(B14,data,2,0)

--
Regards
Roger Govier
"Vass" <mark.nalder_TRAPTHESPAM_@btinternet.com> wrote in message
news:EuqdnTraeqlpM3XfRVnyuw@eclipse.net.uk...
>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
> --
> Vass
>