[libreoffice-users] It would be a bug

Hi all:

I have this charter No 1:

Code    Sells   Office
A       12      Here
S       13      Ala
S       3       Punta
D       5       Ala
A       4       Here


Then I use Pivot Table to get this other chart No. 2 by office from chart No. 1:

Oficina Ventas
Ala     18
Here    16
Punta   3
Total Resultado 37

I've used VLookUp function to get data from chart No 2 to this other chart:

Function: =BUSCARV(A3;'Tabla dinámica_Hoja2_1'.$A$11:$B$15;2)


        Show    Should Show
Office  Sells   Sells
Ala     18      18
Punta   3       3
Here    16      16
Cart    18      0
Lim     16      0

As you can see, the chart is order by office but I got 18 and 16 in "Cart" and "Lim" but It should 
show 0 in both. The LO program get datas from "Ala" and "Here" for "Cart" and "Lim".

What happens ?

Regards,

Jorge Rodríguez


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted