ExcelBanter - is my excel corrupt? VLOOKUP

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - is my excel corrupt? VLOOKUP (https://www.excelbanter.com/excel-discussion-misc-queries/37482-my-excel-corrupt-vlookup.html)

Vass

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

Gordon

"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.

Roger Govier

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

All times are GMT +1. The time now is 09:06 PM.