https://bugs.freedesktop.org/show_bug.cgi?id=85061
Bug ID: 85061
Summary: trouble with vlookup not returning values
Product: LibreOffice
Version: 4.3.1.2 release
Hardware: Other
OS: Windows (All)
Status: UNCONFIRMED
Severity: blocker
Priority: medium
Component: Formula Editor
Assignee: [email protected]
Reporter: [email protected]
Created attachment 107881
--> https://bugs.freedesktop.org/attachment.cgi?id=107881&action=edit
Raw data sheet with filter sheets
I have set up a workbook with a raw data sheet and additional sheets that the
raw data filters down into. The function I used to accomplish this VLOOKUP but
some of the formulas do not work right. In a cell where the formula should
return the contents of a cell on the raw data sheet it remains blank. I know
that the formula functions because the cells around them work with the same
formula but once it gets so-far down the column it just quits. You can see the
problem on sheets Non S.O. and Pattern Shop Sales Orders. In any row of column
"Part #" where there is a number placed should cause the other cells in the row
to fill with their respective data from the raw data sheet if there is data to
be found. I will attach a copy of my workbook for you to look over.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
