Bug 85643 - Función BUSCAR
Summary: Función BUSCAR
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.0.4 release
Hardware: Other Linux (All)
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-10-30 11:04 UTC by fjmuriel
Modified: 2014-10-31 06:35 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description fjmuriel 2014-10-30 11:04:07 UTC 
Si se intenta usar la función BUSCAR para leer el código de las monedas y dar como resultado la tasa de cambio frente al euro, esta función no distingue entre DEM y BEF. Por ejemplo, en la tabla
BEF	ESP	DEM
40,3399	166,386	1,94573

La función buscar da como resultado 40,3399 tanto para BEF y DEM. Pero si se cambia el orden
ESP	DEM	BEF
166,386	1,94573	40,3399

para DEM da el valor correcto y para BEF aparece el código de error #N/D
Comment 1 raal 2014-10-30 18:03:38 UTC 
Hello,
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. 
(Please note that the attachment will be public, remove any sensitive information before attaching it. 
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Comment 2 GerardF 2014-10-30 19:49:50 UTC 
Please read the help of BUSCAR function (LOOKUP in English).
"Search array should be sorted in ascending order"
Comment 3 fjmuriel 2014-10-31 06:35:17 UTC 
Thank you GeradF for your commnets. I just realized that the correct function I must use is BUSCARH (HLOOKUP)