2016-05-23T19:52:21.032366237P0D1LibreOfficeDev/6.1.0.0.alpha0$Linux_X86_64 LibreOffice_project/c6d3d0642e0f5d24cab402a8a7c6f81406d044cf 0 0 30809 2257 view1 2 15 0 0 0 0 2 0 0 0 0 0 80 60 true false 12 6 0 0 0 0 2 0 0 0 0 0 80 60 true false Sheet1 1658 0 80 60 false true true true 12632256 true true true true false false false 1270 1270 1 1 true false 7 true false false 0 false owH+/0Rlc2tKZXRfMjEzMAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpEZXNrSmV0XzIxMzAAAAAAAAAAAAAAAAAAAAAWAAMAwAAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9RGVza0pldF8yMTMwCm9yaWVudGF0aW9uPVBvcnRyYWl0CmNvcGllcz0xCmNvbGxhdGU9ZmFsc2UKbWFyZ2luZGFqdXN0bWVudD0wLDAsMCwwCmNvbG9yZGVwdGg9MjQKcHNsZXZlbD0wCnBkZmRldmljZT0xCmNvbG9yZGV2aWNlPTAKUFBEQ29udGV4RGF0YQpJbnB1dFNsb3Q6TWFpbgBQYWdlU2l6ZTpBNAAAEgBDT01QQVRfRFVQTEVYX01PREUTAER1cGxleE1vZGU6OlVua25vd24= DeskJet_2130 en US true 3 true false true true 12632256 true true false true false true false true 1 false 1270 1270 false 1 true Kč - Kč £ - £ £ - £ £ - £ £ - £ £ - £ ( ) ( ) £ - £ £ - £ € - € R$ - R$ € - € : : : : ( ) ( ) ( ) ( ) / / - - - - : : : : : : / / : ( ) ( ) ( ) - ( ) - ( ) - ( ) - ??? Page 1 ???(???) 00/00/0000, 00:00:00 Page 1/ 99 VLOOKUP Function Result TRUE Sheet Result Description 1 TRUE VLOOKUP tests that ensure there is no partial matching of cell contents even though the document option of “search on whole cell” is turned off. Function Expected Correct FunctionString Comment Unsorted Table Result #N/A #N/A TRUE =VLOOKUP("ABC",$L$2:$M$5,2,0) XYZW 1 #N/A #N/A TRUE =VLOOKUP("BCD",$L$2:$M$5,2,0) ABCD 2 #N/A #N/A TRUE =VLOOKUP("BC",$L$2:$M$5,2,0) DWER 3 2 2 TRUE =VLOOKUP("ABCD",$L$2:$M$5,2,0) REWT 4 4