LibreOfficeDev/26.2.0.0.alpha0$Windows_X86_64 LibreOffice_project/36d2b5d4cec0ac3408b33a1b3e938a5ce9daf897 0 0 31186 13801 view1 1 7 2 0 0 0 0 0 100 60 true false false false false LOOKUP_test 1386 0 100 60 false true true true false true 12632256 true true true true false false false 1000 1000 1 1 true 1 false false false false true true true 0 true true false true false de DE en US 12632256 true true 0 false false true true false 3 false false false 1000 1000 1 1 true false false true true true true true 7 true Sheet1 € - € ??? Page 1 ???(???) 00.00.0000, 00:00:00 Page 1/ 99 LOOKUP function test summary WAHR This test contains references to the sheet “Data” in file “lookup_source.fods”. Make sure the files “lookup_source.fods” and “lookup_target.fods” are placed in the same directory. =AND(C4:C27) Function Expected Correct Comment FunctionString #N/A #N/A WAHR criterion smaller than smallest key =LOOKUP(0;'lookup_source.fods'#$Data.A3:A8;'lookup_source.fods'#$Data.C3:C8) 11 11 WAHR criterion between keys, take lower =LOOKUP(5;'lookup_source.fods'#$Data.A3:A8;'lookup_source.fods'#$Data.C3:C8) 22 22 WAHR exact match =LOOKUP(10;'lookup_source.fods'#$Data.A3:A8;'lookup_source.fods'#$Data.C3:C8) #N/A #N/A WAHR criterion text, but match is number =LOOKUP("A";'lookup_source.fods'#$Data.A3:A8;'lookup_source.fods'#$Data.C3:C8) 44 44 WAHR two exact matches, take upper =LOOKUP("D";'lookup_source.fods'#$Data.A3:A8;'lookup_source.fods'#$Data.C3:C8) #N/A #N/A WAHR external result vector is not expanded =LOOKUP("W";'lookup_source.fods'#$Data.A3:A8;'lookup_source.fods'#$Data.C3:C4) #N/A #N/A WAHR criterion smaller than smallest key =LOOKUP(0;'lookup_source.fods'#$Data.B11:G11;'lookup_source.fods'#$Data.B13:G13) 11 11 WAHR criterion between keys, take lower =LOOKUP(5;'lookup_source.fods'#$Data.B11:G11;'lookup_source.fods'#$Data.B13:G13) 22 22 WAHR exact match =LOOKUP(10;'lookup_source.fods'#$Data.B11:G11;'lookup_source.fods'#$Data.B13:G13) #N/A #N/A WAHR criterion text, but match is number =LOOKUP("A";'lookup_source.fods'#$Data.B11:G11;'lookup_source.fods'#$Data.B13:G13) 44 44 WAHR two exact matches, take upper =LOOKUP("D";'lookup_source.fods'#$Data.B11:G11;'lookup_source.fods'#$Data.B13:G13) #N/A #N/A WAHR external result vector is not expanded =LOOKUP("W";'lookup_source.fods'#$Data.B11:G11;'lookup_source.fods'#$Data.B13:C13) #N/A #N/A WAHR criterion smaller than smallest key =LOOKUP(0;'lookup_source.fods'#$Data.A17:A22;'lookup_source.fods'#$Data.D16:I16) 11 11 WAHR criterion between keys, take lower =LOOKUP(5;'lookup_source.fods'#$Data.A17:A22;'lookup_source.fods'#$Data.D16:I16) 22 22 WAHR exact match =LOOKUP(10;'lookup_source.fods'#$Data.A17:A22;'lookup_source.fods'#$Data.D16:I16) #N/A #N/A WAHR criterion text, but match is number =LOOKUP("A";'lookup_source.fods'#$Data.A17:A22;'lookup_source.fods'#$Data.D16:H16) 44 44 WAHR two exact matches, take upper =LOOKUP("D";'lookup_source.fods'#$Data.A17:A22;'lookup_source.fods'#$Data.D16:I16) #N/A #N/A WAHR external result vector is not expanded =LOOKUP("W";'lookup_source.fods'#$Data.A17:A22;'lookup_source.fods'#$Data.D16:E16) #N/A #N/A WAHR criterion smaller than smallest key =LOOKUP(0;'lookup_source.fods'#$Data.B25:G25;'lookup_source.fods'#$Data.A28:A33) 11 11 WAHR criterion between keys, take lower =LOOKUP(5;'lookup_source.fods'#$Data.B25:G25;'lookup_source.fods'#$Data.A28:A33) 22 22 WAHR exact match =LOOKUP(10;'lookup_source.fods'#$Data.B25:G25;'lookup_source.fods'#$Data.A28:A33) #N/A #N/A WAHR criterion text, but match is number =LOOKUP("A";'lookup_source.fods'#$Data.B25:G25;'lookup_source.fods'#$Data.A28:A33) 44 44 WAHR two exact matches, take upper =LOOKUP("D";'lookup_source.fods'#$Data.B25:G25;'lookup_source.fods'#$Data.A28:A33) #N/A #N/A WAHR external result vector is not expanded =LOOKUP("W";'lookup_source.fods'#$Data.B25:G25;'lookup_source.fods'#$Data.A28:A29) Result Sheet Description 2 Same formulas as in file “lookup_target.fods” but with local references D D T W 33 44 55 66 11 22 33 44 55 66 D D T W 3 11 10 22 D 33 D 44 T 55 W 66 3 10 D D T W 11 22 33 44 55 66 11 22 33 44 55 66 3 10 D D T W 3 10 D D T W 11 22 33 44 55 66 3 11 10 22 D 33 D 44 T 55 W 66 3 10 D D T W 11 22 33 44 55 66 11 22 33 44 55 66 3 10 D D T W 3 10 D D T W 11 22 33 44 55 66