https://bugs.freedesktop.org/show_bug.cgi?id=72915
--- Comment #3 from mariosv <mari...@miguelangel.mobi> ---
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.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
