2016-05-23T19:52:21.032366237P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/989e8bc0d792f0dc5778746fac45de129a22d7ac 0 0 22009 4261 view1 2 8 0 0 0 0 2 0 0 0 0 0 80 60 true false 2 34 0 0 0 0 2 0 0 0 12 0 80 60 true false Sheet2 591 0 80 60 false true true true 12632256 true true true true false false false 1270 1270 1 1 true false 7 false false true true false false false 1270 1270 true true true true true false 12632256 false Lexmark-E352dn en US true true 3 1 true 1 true qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhCkR1cGxleDpOb25lAElucHV0U2xvdDpUcmF5MQBQYWdlU2l6ZTpBNAAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= false 0 Kč - Kč £ - £ £ - £ £ - £ £ - £ £ - £ ( ) ( ) £ - £ £ - £ ??? Page 1 ??? (???) 00/00/0000, 00:00:00 Page 1 / 99 HLOOKUP Function Result TRUE Sheet Result Description 1 TRUE Simple HLOOKUP formulas with local references and values Function Expected Correct FunctionString Comment Axles Bearings Bolts Order ID 10247 10249 10250 10251 10252 10253 2 4 8 B D H 1 3 b d 4 4 TRUE =HLOOKUP("Axles", I1:K4, 2, 1) 4 9 Unit Price 14 18.6 7.7 16.8 64.8 one two three four 7 7 TRUE =HLOOKUP("Bearings", I1:K4, 3, 0) 5 7 10 Quantity 12 9 10 6 20 40 1 5 5 TRUE =HLOOKUP("B", I1:K4, 3, 1) 6 8 11 2 0 11 11 TRUE =HLOOKUP("Bolts", I1:K4, 4) 3 1 c c TRUE =HLOOKUP(3, {1,2,3;"a","b","c";"d","e","f"}, 2, 1) 4 2 16.8 16.8 TRUE =HLOOKUP(10251, M1:S3, 2, 0) 5 3 #N/A #N/A TRUE =HLOOKUP(10248, M1:S3, 2, 0) 6 4 14 14 TRUE =HLOOKUP(10248, M1:S3, 2, 1) 7 a 16.8 16.8 TRUE =HLOOKUP(10251, M1:S3, 2, 0) 8 b #N/A #N/A TRUE =HLOOKUP(U3,$U$1:$AB$1,1) 9 c 2 2 TRUE =HLOOKUP(U4,$U$1:$AB$1,1) A d 2 2 TRUE =HLOOKUP(U5,$U$1:$AB$1,1) B e 4 4 TRUE =HLOOKUP(U6,$U$1:$AB$1,1) C 4 4 TRUE =HLOOKUP(U7,$U$1:$AB$1,1) D 4 4 TRUE =HLOOKUP(U8,$U$1:$AB$1,1) E 4 4 TRUE =HLOOKUP(U9,$U$1:$AB$1,1) F 8 8 TRUE =HLOOKUP(U10,$U$1:$AB$1,1) G 8 8 TRUE =HLOOKUP(U11,$U$1:$AB$1,1) H #N/A #N/A TRUE =HLOOKUP(U12,$U$1:$AB$1,1) I B B TRUE =HLOOKUP(U13,$U$1:$AB$1,1) B B TRUE =HLOOKUP(U14,$U$1:$AB$1,1) D D TRUE =HLOOKUP(U15,$U$1:$AB$1,1) D D TRUE =HLOOKUP(U16,$U$1:$AB$1,1) D D TRUE =HLOOKUP(U17,$U$1:$AB$1,1) D D TRUE =HLOOKUP(U18,$U$1:$AB$1,1) H H TRUE =HLOOKUP(U19,$U$1:$AB$1,1) H H TRUE =HLOOKUP(U20,$U$1:$AB$1,1) #N/A #N/A TRUE =HLOOKUP(AC4,$AC$1:$AF$2,2) one one TRUE =HLOOKUP(AC5,$AC$1:$AF$2,2) one one TRUE =HLOOKUP(AC6,$AC$1:$AF$2,2) two two TRUE =HLOOKUP(AC7,$AC$1:$AF$2,2) two two TRUE =HLOOKUP(AC8,$AC$1:$AF$2,2) #N/A #N/A TRUE =HLOOKUP(AC9,$AC$1:$AF$2,2) three three TRUE =HLOOKUP(AC10,$AC$1:$AF$2,2) three three TRUE =HLOOKUP(AC11,$AC$1:$AF$2,2) four four TRUE =HLOOKUP(AC12,$AC$1:$AF$2,2) four four TRUE =HLOOKUP(AC13,$AC$1:$AF$2,2) 4