Created attachment 91040 [details] Spreedsheet with error in formules Using CONCATENAR and BUSCARV function takes and icorrect value There is attached my wirking sheet In E-S sheet, check that formule in F column contatenates values from D and E columns, but in F13 works until E has 5, more value or none, cause a mistake In E15 must begin in 1 but any number you put in there, in F shows a mistake I tried to chenge data from General to Text without solution Current behavior: Takes an icorrecto value without any razon Expected behavior: The formula takes a value and search it in C-I Sheet an return a value from 7 position, but doesn't work in all files Operating System: Windows 7 Version: 4.1.3.2 release
Created attachment 91061 [details] Sample file modified. Hi Antonio, thanks for reporting. The table where to look is unsorted, this is why you need to put the fourth parameter in BUSCARV() - VLOOKUP() to zero. Maybe you need create the text to search and the searched column with something like: TEXT(D15;"00-")&TEXT(E15;"00") so CI_ES keeps sorted. So you can avoid the fourth parameter. Please take a look to your sample file modified. I can't see a bug there. Changed to NOTABUG, please if you are not agree reopen it.
Thanks for your quick answer I tried many things, but doesn't work The search works fine in most rows, but some of them is not right, thats why a thing is a bug or something cause the logic is fine and works with some data. This problem maybe in inherited from prior design, becouse in Excel occurs the same mistake, working with TEXT or NUMBER. The main difference in Excel is the Warning Icon shown in the cell with the problem. The main need is to look into other table to chaeck is the information is the same (self data integrity check) Did you tried changing the numbers I said? If this is not a bug, please tell me why works in some rows and other doesn't. Thanks a lot for you help. *** Si escribes a mas de uno, usa CCO (con copia oculta) *** Antonio González Fayad - *Asesor Informático* Proveedor de Soluciones en Hardware y Software Cel.300 8112330 "Si no te muestras como eres, el mundo no sabrá darte lo que quieres" 2013/12/20 <bugzilla-daemon@freedesktop.org> > *Comment # 1 <https://bugs.freedesktop.org/show_bug.cgi?id=72915#c1> on > bug 72915 <https://bugs.freedesktop.org/show_bug.cgi?id=72915> from mariosv > <mariosv@miguelangel.mobi> * > > Created attachment 91061 [details] <https://bugs.freedesktop.org/attachment.cgi?id=91061> [details] <https://bugs.freedesktop.org/attachment.cgi?id=91061&action=edit> > Sample file modified. > > Hi Antonio, thanks for reporting. > > The table where to look is unsorted, this is why you need to put the fourth > parameter in BUSCARV() - VLOOKUP() to zero. > > Maybe you need create the text to search and the searched column with something > like: > TEXT(D15;"00-")&TEXT(E15;"00") so CI_ES keeps sorted. So you can avoid the > fourth parameter. > > Please take a look to your sample file modified. > > I can't see a bug there. > Changed to NOTABUG, please if you are not agree reopen it. > > ------------------------------ > You are receiving this mail because: > > - You reported the bug. > >
Please Antonio don't reproduce the comment, only copy the paragraphs for comment about. Please what it exactly what not works for you? In CI_ES there are not pairs for 31-6 or higher. I you want an exact match add the fourth parameter with 0 in BUSCARV() when non exist result is #N/A. (Please take a look to the function help). But if you want verify several conditions there are other options to do it: E-S.F1: =SUMPRODUCT($D2='C-I'.$A$2:$A$288;$E2='C-I'.$B$2:$B$288) or E-S.F1: =COUNTIFS('C-I'.$A$2:$A$288;$D2;'C-I'.$B$2:$B$288;$E2) the result is 1 if exist or 0 for not, what you can format as TRUE/FALSE.
Ok, now I know you are taking about With the fourth parameter in 0 works fine. Thanks a LOT and apologize for any inconvenience about my comment. Now is appropiate to close this issue with NOT A BUG