| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
"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. |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Excel - Corrupt File / Urgent | Excel Discussion (Misc queries) | |||
| Vlookup in Excel | Excel Worksheet Functions | |||
| Vlookup and Indexing in excel | Excel Worksheet Functions | |||
| Excel Problem: VLookup | Excel Worksheet Functions | |||
Linear Mode
