2016-05-23T19:52:21.032366237P0D1LibreOfficeDev/6.1.0.0.alpha0$Linux_X86_64 LibreOffice_project/83b7bfc0efefb3c77e5c59553320e98539250c62 0 0 72815 28975 view1 2 8 0 0 0 0 2 0 0 0 0 0 80 60 true false 4 46 0 0 0 0 2 0 0 0 18 0 80 60 true false Sheet2 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 lAH+/0Rlc2tKZXRfMjEzMAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpEZXNrSmV0XzIxMzAAAAAAAAAAAAAAAAAAAAAWAAMAsQAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9RGVza0pldF8yMTMwCm9yaWVudGF0aW9uPVBvcnRyYWl0CmNvcGllcz0xCmNvbGxhdGU9ZmFsc2UKbWFyZ2luZGFqdXN0bWVudD0wLDAsMCwwCmNvbG9yZGVwdGg9MjQKcHNsZXZlbD0wCnBkZmRldmljZT0xCmNvbG9yZGV2aWNlPTAKUFBEQ29udGV4RGF0YQpQYWdlU2l6ZTpBNAAAEgBDT01QQVRfRFVQTEVYX01PREUTAER1cGxleE1vZGU6OlVua25vd24= 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 Simple VLOOKUP formulas with local references and values Function Expected Correct FunctionString Comment nr fruit lookup table crit. b a 1 one 1 3 b d table column1 expected False Bananas Bananas TRUE =VLOOKUP(111,I1:J5,2,FALSE()) 111 Bananas C 1 Case 1 DD d b 3 two one two three four 1 apple 3 cherry 2 2 TRUE =VLOOKUP(P2,$L$2:$M$8,2,0) 112 Apples DD 2 Case 2 D. c b three 2 banana 2 banana 2 2 TRUE =VLOOKUP(P3,$L$2:$M$8,2,0) 113 Pears EF 3 Case 3 EF d d four 3 cherry 4 blackberry 3 3 TRUE =VLOOKUP(P4,$L$2:$M$8,2,0) 114 Oranges E.F 4 Case 4 E.F e query value 4 blackberry 1 apple 4 4 TRUE =VLOOKUP(P5,$L$2:$M$8,2,0) E\.F 5 Case 5 E\nF 0 3 3 TRUE =VLOOKUP(P6,$L$2:$M$8,2,0) F 6 Case 6 E\.F 1 4 4 TRUE =VLOOKUP(P7,$L$2:$M$8,2,0) G 7 2 #N/A #N/A TRUE =VLOOKUP(S1,$R$1:$R$2,1,1) 3 b b TRUE =VLOOKUP(S2,$R$1:$R$2,1,1) Unsorted table Crit. 4 b b TRUE =VLOOKUP(S3,$R$1:$R$2,1,1) ABC ABC a d d TRUE =VLOOKUP(S4,$R$1:$R$2,1,1) abcd AB b d d TRUE =VLOOKUP(S5,$R$1:$R$2,1,1) coté ABCD c #N/A #N/A TRUE =VLOOKUP($W6,$U$1:$V$4,2) côte coté d one one TRUE =VLOOKUP($W7,$U$1:$V$4,2) côté côte e one one TRUE =VLOOKUP($W8,$U$1:$V$4,2) cote côté two two TRUE =VLOOKUP($W9,$U$1:$V$4,2) Dürst cote two two TRUE =VLOOKUP($W10,$U$1:$V$4,2) DUERST Dürst #N/A #N/A TRUE =VLOOKUP($W11,$U$1:$V$4,2) iiii DUERST three three TRUE =VLOOKUP($W12,$U$1:$V$4,2) İİİİ iiii three three TRUE =VLOOKUP($W13,$U$1:$V$4,2) ıııı İİİİ four four TRUE =VLOOKUP($W14,$U$1:$V$4,2) IIII ıııı four four TRUE =VLOOKUP($W15,$U$1:$V$4,2) ABCDEF IIII cherry cherry TRUE =VLOOKUP(AF2,table,2,0) iii banana banana TRUE =VLOOKUP(AF3,table,2,0) İİİ blackberry blackberry TRUE =VLOOKUP(AF4,table,2,0) ııı apple apple TRUE =VLOOKUP(AF5,table,2,0) III cherry cherry TRUE =AH2 ABCDEF banana banana TRUE =AH3 blackberry blackberry TRUE =AH4 apple apple TRUE =AH5 cherry cherry TRUE {=VLOOKUP(AF2:AF5,table,2,0)} banana banana TRUE {=VLOOKUP(AF2:AF5,table,2,0)} blackberry blackberry TRUE {=VLOOKUP(AF2:AF5,table,2,0)} apple apple TRUE {=VLOOKUP(AF2:AF5,table,2,0)} ABC ABC TRUE =VLOOKUP(M11, L$11:M$16,1,0) #N/A #N/A TRUE =VLOOKUP(M12, L$11:M$32,1,0) abcd abcd TRUE =VLOOKUP(M13, L$11:M$32,1,0) coté coté TRUE =VLOOKUP(M14, L$11:M$32,1,0) côte côte TRUE =VLOOKUP(M15, L$11:M$32,1,0) côté côté TRUE =VLOOKUP(M16, L$11:M$32,1,0) cote cote TRUE =VLOOKUP(M17, L$11:M$32,1,0) Dürst Dürst TRUE =VLOOKUP(M18, L$11:M$32,1,0) DUERST DUERST TRUE =VLOOKUP(M19, L$11:M$32,1,0) iiii iiii TRUE =VLOOKUP(M20, L$11:M$32,1,0) İİİİ İİİİ TRUE =VLOOKUP(M21, L$11:M$32,1,0) iiii ıııı TRUE =VLOOKUP(M22, L$11:M$32,1,0) Excel interoperability bug, forced to TRUE iiii iiii TRUE =VLOOKUP(M23, L$11:M$32,1,0) #N/A #N/A TRUE =VLOOKUP(M24, L$11:M$32,1,0) #N/A #N/A TRUE =VLOOKUP(M25, L$11:M$32,1,0) #N/A #N/A TRUE =VLOOKUP(M26, L$11:M$32,1,0) #N/A #N/A TRUE =VLOOKUP(M27, L$11:M$32,1,0) ABCDEF ABCDEF TRUE =VLOOKUP(M28, L$11:M$32,1,0) DUERST DUERST TRUE =VLOOKUP(M19, L$11:M$32,1,0) cote cote TRUE =VLOOKUP("côted",L$11:M$32,1,1) abcd abcd TRUE =VLOOKUP("côt",L$11:M$32,1,1) cote DUERST TRUE =VLOOKUP("Dürs",L$11:M$32,1,1) Excel interoperability bug, forced to TRUE cote DUERST TRUE =VLOOKUP("Durs",L$11:M$32,1,1) Excel interoperability bug, forced to TRUE #N/A #N/A TRUE =VLOOKUP("côted",L$11:M$32,1,0) #N/A #N/A TRUE =VLOOKUP("côt",L$11:M$32,1,0) #N/A #N/A TRUE =VLOOKUP("Dürs",L$11:M$32,1,0) #N/A #N/A TRUE =VLOOKUP("Durs",L$11:M$32,1,0) 4