is my excel corrupt? VLOOKUP

V

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
 
G

Gordon

Vass said:
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
Click to expand...

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

Roger Govier

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

=VLOOKUP(B14,data,2,0)
 
Top