| View previous topic :: View next topic |
| Author |
Message |
patll
General User
Joined: 23 Jun 2008
Posts: 9
|
 Posted: Wed Jul 13, 2011 9:31 pm Post subject: vlookup strange result, same result duplicated till diff... |
 |
|
i have oo3.2.0 and worked thru learning how to use the VLookup. I seems to work, yet as the formula goes down a col, when it hits a positive criteria it works, then (this is what is strage) every formula down issues the same result until a new criteria is met then the formula does it again and continues to repeat the result of the next met criteria(even though that row index doesn't match anything)
search criteria is 1st col, the array $A$1:$C$64, the index is 3 (for 3rd col the result will come from if matched and thus the location of the formula in the 3rd col and copied down the rows for 1600 rows to match/fill in the result in col 3 when the criteria is met for that row.
=VLOOKUP(A116;$A$1:$C$64;3)
How to eliminate the duplicate results in each row even though there is no criteria match for that row?
any help is appreciated
Thanks
P |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Thu Jul 14, 2011 1:15 am Post subject: |
|
|
No, it does not work this way unless you add the 4th parameter.
VLOOKUP(what ; where ; which ; 0)
It is the same matter with all spreadsheets since 20 years at least.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
patll
General User
Joined: 23 Jun 2008
Posts: 9
|
| Posted: Thu Jul 14, 2011 7:48 pm Post subject: |
|
|
| Villeroy wrote: | No, it does not work this way unless you add the 4th parameter.
VLOOKUP(what ; where ; which ; 0)
It is the same matter with all spreadsheets since 20 years at least. |
Thanks that seemed to work, however the help file says it, the 4th parameter is optional. |
|
| Back to top |
|
|
gerard24
OOo Enthusiast
Joined: 08 Jul 2011
Posts: 100
Location: France
|
| Posted: Thu Jul 14, 2011 10:29 pm Post subject: |
|
|
| patll wrote: |
Thanks that seemed to work, however the help file says it, the 4th parameter is optional. |
Optional doesn't mean Unnecessary, nor Useless. 
_________________
LibreOffice 3.5.0 on Windows Vista |
|
| Back to top |
|
|
|
