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