| View previous topic :: View next topic |
| Author |
Message |
jldavid
Newbie
Joined: 01 Dec 2005
Posts: 3
|
 Posted: Thu Dec 01, 2005 8:39 am Post subject: VLOOKUP Failures |
 |
|
I have a spreadsheet where I do a lot of VLOOKUPs using both direct and indirect
referencing of criteria. On occasion, VLOOKUP goes nuts and refuses to find a valid
entry. Worse, at other times it picks up the entry from a totally different row.
This problem would occasionally happen in 1.1.3. In 2.0, it is happening a LOT.
What the hell is going on? |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Thu Dec 01, 2005 8:45 am Post subject: |
|
|
| If you want to lookup the exact value set the optional fourth parameter to FALSE or zero. |
|
| Back to top |
|
|
sstrider
General User
Joined: 30 Nov 2005
Posts: 40
Location: London UK
|
| Posted: Thu Dec 01, 2005 1:04 pm Post subject: Vlookup probs |
|
|
Vlookup works ok - get an example i used it in here
http://www.ridj.biz/OOOsamples/AutoSOrt.ods
You need the FALSE value if you looking up an unsorted list |
|
| Back to top |
|
|
|
