"Vass" wrote in message
...
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.