2016-09-03T08:45:20.467594215P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/a8a7b7114d96b2013b00e9bc0ced81aad5495457 0 0 88104 402563 view1 1 5 0 0 0 0 2 0 0 0 0 0 65 60 true false 1 7 0 0 0 0 2 0 0 0 0 0 65 60 true false 9 880 0 0 0 0 2 0 0 0 698 0 65 60 true false Sheet2 1241 0 65 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 cs CZ de DE en US nl NL true true 3 1 true 1 true rQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMA0wAAAAAAAAAIAFZUAAAkbQAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhCkR1cGxleDpOb25lAElucHV0U2xvdDpUcmF5MQBQYWdlU2l6ZTpMZXR0ZXIAABIAQ09NUEFUX0RVUExFWF9NT0RFCgBEVVBMRVhfT0ZG false 0 Kč - Kč ( ) - Kč - Kč Kč - Kč Kč - Kč Kč - Kč £ - £ £ - £ £ - £ £ - £ £ - £ ( ) ( ) £ - £ £ - £ € - € - € / / / / € - € Kč - Kč Kč - Kč Kč - Kč Kč - Kč - - - - - - Kč - Kč - Kč - - Kč - Kč - Kč : : : : Yes Yes No True True False On On Off ¥€ ( € ) € - € $ ($ ) € - € € - € € - € € - € - - € - € - € - - € - € - € $ ($ ) $ ($ ) $ ($ ) ( ) - $ $ ( ) $ - $ $ ( ) $ - € ( € ) \ \- \ \- \ \- \ \- \ \ - \ - - - \ \ - \ - - - - - - - $ $( ) $- ( ) - $ $( ) $- ( ) - % % % % % % % % % % € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € % % % % % % $ ( $ ) % % - % - - - £ - £ £ - £ % - % DM - DM DM - DM DM - DM DM - DM - - DM - DM - DM - - DM - DM - DM Ouch! - - Error detected! - Result=0 - No Errordetection / / / / ( ) - $ $ ( ) $ - ( ) - $ $ ( ) $ - £ -£ £ -£ £ -£ £ -£ - - £ -£ £ - - - £ -£ £ - ￥ - ￥ DM - DM DM - DM DM - DM DM - DM DM - DM - - £ -£ £- - - £ -£ £- $ $( ) $- ( ) - $ $( ) $- ( ) - ( ) - € € - ok ERR € ( € ) / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) - : : : ( ) % ( ) - ( ) - ( ) - ( ) - . . : : : . . : - - - - € - € € - € € - € € - € - - - - : : : / / : % / / / / , ??? Page 1 ??? (???) 00/00/0000, 00:00:00 Page 1 / 99 LOOKUP Function Result TRUE Sheet Result Description 1 TRUE Simple LOOKUP formulas with local references and values Function Expected Correct FunctionString Comment Date 1 Bug 71589 yy yy TRUE =LOOKUP("cc",Sheet2.P12:P17,R12:R17) 11/01/2013 2 1 2 3 E test test TRUE =LOOKUP("cc",Sheet2.P12:P17,R3:R9) 11/02/2013 tes PLUM PLUM TRUE =LOOKUP(3,Y2:AB2,Y6:AB6) 11/03/2013 test VAN VAN TRUE =LOOKUP("E",Y2:AB2,Y6:AB6) 11/04/2013 test 2 BLUE PEAR TRUCK #N/A #N/A TRUE =LOOKUP(K23,K20:R20,K20:R20) 11/05/2013 t 3 GREEN PLUM VAN 2 2 TRUE =LOOKUP(K24,K20:R20,K20:R20) 11/06/2013 a 2 2 TRUE =LOOKUP(K25,K20:R20,K20:R20) 11/07/2013 testing 4 4 TRUE =LOOKUP(K26,K20:R20,K20:R20) 11/08/2013 testing2 4 4 TRUE =LOOKUP(K27,K20:R20,K20:R20) 4 4 TRUE =LOOKUP(K28,K20:R20,K20:R20) 4 4 TRUE =LOOKUP(K29,K20:R20,K20:R20) TODO aa 1 xx 8 8 TRUE =LOOKUP(K30,K20:R20,K20:R20) LOOKUP Kohei's test case from bug AOO#74245 bb 2 zz 8 8 TRUE =LOOKUP(K31,K20:R20,K20:R20) cc 3 yy #N/A #N/A TRUE =LOOKUP(K32,K20:R20,K20:R20) dd 4 ww B B TRUE =LOOKUP(K33,K20:R20,K20:R20) ee 5 qq B B TRUE =LOOKUP(K34,K20:R20,K20:R20) ff 6 bb D D TRUE =LOOKUP(K35,K20:R20,K20:R20) D D TRUE =LOOKUP(K36,K20:R20,K20:R20) D D TRUE =LOOKUP(K37,K20:R20,K20:R20) 2 4 8 B D H D D TRUE =LOOKUP(K38,K20:R20,K20:R20) H H TRUE =LOOKUP(K39,K20:R20,K20:R20) Lookup H H TRUE =LOOKUP(K40,K20:R20,K20:R20) 1 a a TRUE =LOOKUP(I2,$Data.A2:A9,$Data.B2:B9) 2 0 TRUE =LOOKUP(I3,$Data.$A$2:A10,$Data.$B$2:B10) 3 b b TRUE =LOOKUP(I4,$Data.$A$2:A11,$Data.$B$2:B11) 4 0 TRUE =LOOKUP(I5,$Data.$A$2:A12,$Data.$B$2:B12) 5 c c TRUE =LOOKUP(I6,$Data.$A$2:A13,$Data.$B$2:B13) 6 TRUE =LOOKUP(I7,$Data.$A$2:A14,$Data.$B$2:B14) 7 d d TRUE =LOOKUP(I8,$Data.$A$2:A15,$Data.$B$2:B15) 8 0 TRUE =LOOKUP(I9,$Data.$A$2:A16,$Data.$B$2:B16) 9 7.33333333333333 7.33333333333333 TRUE =LOOKUP(4, K43:M43*2, K45:M45/3) A 2 2 TRUE =LOOKUP(2,K43) B 1 1 TRUE =LOOKUP(1,1) C 1 1 TRUE =LOOKUP(1,{1,2}) D 22 22 TRUE =LOOKUP(2,K43,K45) E 3 3 TRUE =LOOKUP(1,1,3) F 3 3 TRUE =LOOKUP(1,{1,2},{3,4}) G #N/A #N/A TRUE =LOOKUP(K49,L49:L56) H 0 0 TRUE =LOOKUP(K50,L49:L56) I #N/A #N/A TRUE =LOOKUP(K51,L49:L56) 1 1 TRUE =LOOKUP(K52,L49:L56) 2 2 TRUE =LOOKUP(K53,L49:L56) 2 4 8 constants lookups 3 3 TRUE =LOOKUP(K54,L49:L56) #N/A #N/A TRUE =LOOKUP(K55,L49:L56) 22 44 88 b b TRUE =LOOKUP(K56,L49:L56) forced array c c TRUE =LOOKUP(K57,L49:L56) y y TRUE =LOOKUP(K58,L49:L56) mixed lookupno result vector mixed lookupresult vector mixed lookupresult matrix search vector numeric search vector string #N/A #N/A TRUE =LOOKUP(K49,L49:L56,M49:M56) -1 0 0 2 0 0.000000 TRUE =LOOKUP(K50,L49:L56,M49:M56) 0 1 11 11 2 #N/A #N/A TRUE =LOOKUP(K51,L49:L56,M49:M56) 2 22 22 2 11 11.000000 TRUE =LOOKUP(K52,L49:L56,M49:M56) 1 3 33 33 2 22 22 TRUE =LOOKUP(K53,L49:L56,M49:M56) 2 b bb bb 2 33 33 TRUE =LOOKUP(K54,L49:L56,M49:M56) 4 c cc cc 2 #N/A #N/A TRUE =LOOKUP(K55,L49:L56,M49:M56) a x xx xx 2 bb bb TRUE =LOOKUP(K56,L49:L56,M49:M56) b y yy yy 2 cc cc TRUE =LOOKUP(K57,L49:L56,M49:M56) d yy yy TRUE =LOOKUP(K58,L49:L56,M49:M56) z #N/A #N/A TRUE =LOOKUP(K49,L49:N56) 0 2 0 2 TRUE =LOOKUP(K50,L49:N56) single data lookup #N/A #N/A TRUE =LOOKUP(K51,L49:N56) 11 2 11 2 TRUE =LOOKUP(K52,L49:N56) 22 2 22 2 TRUE =LOOKUP(K53,L49:N56) 33 2 33 2 TRUE =LOOKUP(K54,L49:N56) #N/A #N/A TRUE =LOOKUP(K55,L49:N56) bb 2 bb 2 TRUE =LOOKUP(K56,L49:N56) cc 2 cc 2 TRUE =LOOKUP(K57,L49:N56) yy 2 yy 2 TRUE =LOOKUP(K58,L49:N56) #N/A #N/A TRUE =LOOKUP(K49,L49:L52,M49:M56) 0 0.000000 TRUE =LOOKUP(K50,L49:L52,M49:M56) #N/A #N/A TRUE =LOOKUP(K51,L49:L52,M49:M56) 11 11.000000 TRUE =LOOKUP(K52,L49:L52,M49:M56) single value in data 22 22.000000 TRUE =LOOKUP(K53,L49:L52,M49:M56) -1 1 zero c 33 33.000000 TRUE =LOOKUP(K54,L49:L52,M49:M56) 0 1 one c #N/A #N/A TRUE =LOOKUP(K55,L49:L52,M49:M56) 1 two c #N/A #N/A TRUE =LOOKUP(K56,L49:L52,M49:M56) 1 three c #N/A #N/A TRUE =LOOKUP(K57,L49:L52,M49:M56) 2 1 four c #N/A #N/A TRUE =LOOKUP(K58,L49:L52,M49:M56) 4 1 five c #N/A #N/A TRUE =LOOKUP(K49,L53:L56,M49:M56) a 1 six c #N/A #N/A TRUE =LOOKUP(K50,L53:L56,M49:M56) b 1 seven c #N/A #N/A TRUE =LOOKUP(K51,L53:L56,M49:M56) d 1 eight c #N/A #N/A TRUE =LOOKUP(K52,L53:L56,M49:M56) #N/A #N/A TRUE =LOOKUP(K53,L53:L56,M49:M56) #N/A #N/A TRUE =LOOKUP(K54,L53:L56,M49:M56) #N/A #N/A TRUE =LOOKUP(K55,L53:L56,M49:M56) 0 0 TRUE =LOOKUP(K56,L53:L56,M49:M56) 11 11 TRUE =LOOKUP(K57,L53:L56,M49:M56) 33 33 TRUE =LOOKUP(K58,L53:L56,M49:M56) #N/A #N/A TRUE =LOOKUP(K49,L49,M49:M56) 0 0 TRUE =LOOKUP(K50,L49,M49:M56) #N/A #N/A TRUE =LOOKUP(K51,L49,M49:M56) 0 0 TRUE =LOOKUP(K52,L49,M49:M56) 0 0 TRUE =LOOKUP(K53,L49,M49:M56) 0 0 TRUE =LOOKUP(K54,L49,M49:M56) #N/A #N/A TRUE =LOOKUP(K55,L49,M49:M56) #N/A #N/A TRUE =LOOKUP(K56,L49,M49:M56) #N/A #N/A TRUE =LOOKUP(K57,L49,M49:M56) #N/A #N/A TRUE =LOOKUP(K58,L49,M49:M56) #N/A #N/A TRUE =LOOKUP(K49,L50,M49:M56) #N/A #N/A TRUE =LOOKUP(K50,L50,M49:M56) #N/A #N/A TRUE =LOOKUP(K51,L50,M49:M56) 0 0 TRUE =LOOKUP(K52,L50,M49:M56) 0 0 TRUE =LOOKUP(K53,L50,M49:M56) 0 0 TRUE =LOOKUP(K54,L50,M49:M56) #N/A #N/A TRUE =LOOKUP(K55,L50,M49:M56) #N/A #N/A TRUE =LOOKUP(K56,L50,M49:M56) #N/A #N/A TRUE =LOOKUP(K57,L50,M49:M56) #N/A #N/A TRUE =LOOKUP(K58,L50,M49:M56) #N/A #N/A TRUE =LOOKUP(K49,L51,M49:M56) #N/A #N/A TRUE =LOOKUP(K50,L51,M49:M56) #N/A #N/A TRUE =LOOKUP(K51,L51,M49:M56) #N/A #N/A TRUE =LOOKUP(K52,L51,M49:M56) 0 0 TRUE =LOOKUP(K53,L51,M49:M56) 0 0 TRUE =LOOKUP(K54,L51,M49:M56) #N/A #N/A TRUE =LOOKUP(K55,L51,M49:M56) #N/A #N/A TRUE =LOOKUP(K56,L51,M49:M56) #N/A #N/A TRUE =LOOKUP(K57,L51,M49:M56) #N/A #N/A TRUE =LOOKUP(K58,L51,M49:M56) #N/A #N/A TRUE =LOOKUP(K49,L52,M49:M56) #N/A #N/A TRUE =LOOKUP(K50,L52,M49:M56) #N/A #N/A TRUE =LOOKUP(K51,L52,M49:M56) #N/A #N/A TRUE =LOOKUP(K52,L52,M49:M56) #N/A #N/A TRUE =LOOKUP(K53,L52,M49:M56) 0 0 TRUE =LOOKUP(K54,L52,M49:M56) #N/A #N/A TRUE =LOOKUP(K55,L52,M49:M56) #N/A #N/A TRUE =LOOKUP(K56,L52,M49:M56) #N/A #N/A TRUE =LOOKUP(K57,L52,M49:M56) #N/A #N/A TRUE =LOOKUP(K58,L52,M49:M56) #N/A #N/A TRUE =LOOKUP(K49,L56,M49:M56) #N/A #N/A TRUE =LOOKUP(K50,L56,M49:M56) #N/A #N/A TRUE =LOOKUP(K51,L56,M49:M56) #N/A #N/A TRUE =LOOKUP(K52,L56,M49:M56) #N/A #N/A TRUE =LOOKUP(K53,L56,M49:M56) #N/A #N/A TRUE =LOOKUP(K54,L56,M49:M56) #N/A #N/A TRUE =LOOKUP(K55,L56,M49:M56) #N/A #N/A TRUE =LOOKUP(K56,L56,M49:M56) #N/A #N/A TRUE =LOOKUP(K57,L56,M49:M56) 0 0 TRUE =LOOKUP(K58,L56,M49:M56) #N/A #N/A TRUE =LOOKUP(K49,L55,M49:M56) #N/A #N/A TRUE =LOOKUP(K50,L55,M49:M56) #N/A #N/A TRUE =LOOKUP(K51,L55,M49:M56) #N/A #N/A TRUE =LOOKUP(K52,L55,M49:M56) #N/A #N/A TRUE =LOOKUP(K53,L55,M49:M56) #N/A #N/A TRUE =LOOKUP(K54,L55,M49:M56) #N/A #N/A TRUE =LOOKUP(K55,L55,M49:M56) #N/A #N/A TRUE =LOOKUP(K56,L55,M49:M56) #N/A #N/A TRUE =LOOKUP(K57,L55,M49:M56) 0 0 TRUE =LOOKUP(K58,L55,M49:M56) #N/A #N/A TRUE =LOOKUP(K49,L54,M49:M56) #N/A #N/A TRUE =LOOKUP(K50,L54,M49:M56) #N/A #N/A TRUE =LOOKUP(K51,L54,M49:M56) #N/A #N/A TRUE =LOOKUP(K52,L54,M49:M56) #N/A #N/A TRUE =LOOKUP(K53,L54,M49:M56) #N/A #N/A TRUE =LOOKUP(K54,L54,M49:M56) #N/A #N/A TRUE =LOOKUP(K55,L54,M49:M56) #N/A #N/A TRUE =LOOKUP(K56,L54,M49:M56) 0 0 TRUE =LOOKUP(K57,L54,M49:M56) 0 0 TRUE =LOOKUP(K58,L54,M49:M56) #N/A #N/A TRUE =LOOKUP(K49,L53,M49:M56) #N/A #N/A TRUE =LOOKUP(K50,L53,M49:M56) #N/A #N/A TRUE =LOOKUP(K51,L53,M49:M56) #N/A #N/A TRUE =LOOKUP(K52,L53,M49:M56) #N/A #N/A TRUE =LOOKUP(K53,L53,M49:M56) #N/A #N/A TRUE =LOOKUP(K54,L53,M49:M56) #N/A #N/A TRUE =LOOKUP(K55,L53,M49:M56) 0 0.000000 TRUE =LOOKUP(K56,L53,M49:M56) 0 0.000000 TRUE =LOOKUP(K57,L53,M49:M56) 0 0.000000 TRUE =LOOKUP(K58,L53,M49:M56) #N/A #N/A TRUE =LOOKUP(K73,L73:L81,M73:M81) #N/A #N/A TRUE =LOOKUP(K74,L73:L81,M73:M81) #N/A #N/A TRUE =LOOKUP(K75,L73:L81,M73:M81) eight eight TRUE =LOOKUP(K76,L73:L81,M73:M81) eight eight TRUE =LOOKUP(K77,L73:L81,M73:M81) eight eight TRUE =LOOKUP(K78,L73:L81,M73:M81) #N/A #N/A TRUE =LOOKUP(K79,L73:L81,M73:M81) #N/A #N/A TRUE =LOOKUP(K80,L73:L81,M73:M81) #N/A #N/A TRUE =LOOKUP(K81,L73:L81,M73:M81) #N/A #N/A TRUE =LOOKUP(K73,Q73:Q81,M73:M81) #N/A #N/A TRUE =LOOKUP(K74,Q73:Q81,M73:M81) #N/A #N/A TRUE =LOOKUP(K75,Q73:Q81,M73:M81) #N/A #N/A TRUE =LOOKUP(K76,Q73:Q81,M73:M81) #N/A #N/A TRUE =LOOKUP(K77,Q73:Q81,M73:M81) #N/A #N/A TRUE =LOOKUP(K78,Q73:Q81,M73:M81) #N/A #N/A TRUE =LOOKUP(K79,Q73:Q81,M73:M81) #N/A #N/A TRUE =LOOKUP(K80,Q73:Q81,M73:M81) eight eight TRUE =LOOKUP(K81,Q73:Q81,M73:M81) A A TRUE =LOOKUP(L187,I187:I212) A Andy A B B TRUE =LOOKUP(L188,I187:I212) B Bruce B C C TRUE =LOOKUP(L189,I187:I212) C Charlie C D D TRUE =LOOKUP(L190,I187:I212) D David D E E TRUE =LOOKUP(L$191,I187:I212) E Edward E F F TRUE =LOOKUP(L192,I187:I212) F Frank F G G TRUE =LOOKUP(L$193,I187:I212) G George G H H TRUE =LOOKUP(L194,I187:I212) H Henry H I I TRUE =LOOKUP(L195,I187:I212) I Ira I J J TRUE =LOOKUP(L196,I187:I212) J Jamie J K K TRUE =LOOKUP(L197,I187:I212) K Kevin K L L TRUE =LOOKUP(L198,I187:I212) L Leonard L M M TRUE =LOOKUP(L199,I187:I212) M Michael M N N TRUE =LOOKUP(L200,I187:I212) N Noel N O O TRUE =LOOKUP(L201,I187:I212) O Oliver O P P TRUE =LOOKUP(L202,I187:I212) P Peter P Q Q TRUE =LOOKUP(L203,I187:I212) Q Quincy Q R R TRUE =LOOKUP(L204,I187:I212) R Rachel R S S TRUE =LOOKUP(L205,I187:I212) S Stuart S T T TRUE =LOOKUP(L206,I187:I212) T Tom T U U TRUE =LOOKUP(L207,I187:I212) U Uma U V V TRUE =LOOKUP(L208,I187:I212) V Victor V W W TRUE =LOOKUP(L209,I187:I212) W Wesley W X X TRUE =LOOKUP(L210,I187:I212) X Xander X Y Y TRUE =LOOKUP(L211,I187:I212) Y Yoko Y Z Z TRUE =LOOKUP(L212,I187:I212) Z Zebulon Z Andy Andy TRUE =LOOKUP(L187,I187:J212) Bruce Bruce TRUE =LOOKUP(L188,I187:J212) Charlie Charlie TRUE =LOOKUP(L189,I187:J212) David David TRUE =LOOKUP(L190,I187:J212) Edward Edward TRUE =LOOKUP(L$191,I187:J212) Frank Frank TRUE =LOOKUP(L192,I187:J212) George George TRUE =LOOKUP(L193,I187:J212) Henry Henry TRUE =LOOKUP(L194,I187:J212) Ira Ira TRUE =LOOKUP(L195,I187:J212) Jamie Jamie TRUE =LOOKUP(L196,I187:J212) Kevin Kevin TRUE =LOOKUP(L197,I187:J212) Leonard Leonard TRUE =LOOKUP(L198,I187:J212) Michael Michael TRUE =LOOKUP(L199,I187:J212) Noel Noel TRUE =LOOKUP(L200,I187:J212) Oliver Oliver TRUE =LOOKUP(L201,I187:J212) Peter Peter TRUE =LOOKUP(L202,I187:J212) Quincy Quincy TRUE =LOOKUP(L203,I187:J212) Rachel Rachel TRUE =LOOKUP(L204,I187:J212) Stuart Stuart TRUE =LOOKUP(L205,I187:J212) Tom Tom TRUE =LOOKUP(L206,I187:J212) Uma Uma TRUE =LOOKUP(L207,I187:J212) Victor Victor TRUE =LOOKUP(L208,I187:J212) Wesley Wesley TRUE =LOOKUP(L209,I187:J212) Xander Xander TRUE =LOOKUP(L210,I187:J212) Yoko Yoko TRUE =LOOKUP(L211,I187:J212) Zebulon Zebulon TRUE =LOOKUP(L212,I187:J212) Andy Andy TRUE =LOOKUP(L187,I187:I212,J187:J212) Bruce Bruce TRUE =LOOKUP(L188,I187:I212,J187:J212) Charlie Charlie TRUE =LOOKUP(L189,I187:I212,J187:J212) David David TRUE =LOOKUP(L190,I187:I212,J187:J212) Edward Edward TRUE =LOOKUP(L191,I187:I212,J187:J212) Frank Frank TRUE =LOOKUP(L192,I187:I212,J187:J212) George George TRUE =LOOKUP(L193,I187:I212,J187:J212) Henry Henry TRUE =LOOKUP(L194,I187:I212,J187:J212) Ira Ira TRUE =LOOKUP(L195,I187:I212,J187:J212) Jamie Jamie TRUE =LOOKUP(L196,I187:I212,J187:J212) Kevin Kevin TRUE =LOOKUP(L197,I187:I212,J187:J212) Leonard Leonard TRUE =LOOKUP(L198,I187:I212,J187:J212) Michael Michael TRUE =LOOKUP(L199,I187:I212,J187:J212) Noel Noel TRUE =LOOKUP(L200,I187:I212,J187:J212) Oliver Oliver TRUE =LOOKUP(L201,I187:I212,J187:J212) Peter Peter TRUE =LOOKUP(L202,I187:I212,J187:J212) Quincy Quincy TRUE =LOOKUP(L203,I187:I212,J187:J212) Rachel Rachel TRUE =LOOKUP(L204,I187:I212,J187:J212) Stuart Stuart TRUE =LOOKUP(L205,I187:I212,J187:J212) Tom Tom TRUE =LOOKUP(L206,I187:I212,J187:J212) Uma Uma TRUE =LOOKUP(L207,I187:I212,J187:J212) Victor Victor TRUE =LOOKUP(L208,I187:I212,J187:J212) Wesley Wesley TRUE =LOOKUP(L209,I187:I212,J187:J212) Xander Xander TRUE =LOOKUP(L210,I187:I212,J187:J212) Yoko Yoko TRUE =LOOKUP(L211,I187:I212,J187:J212) Zebulon Zebulon TRUE =LOOKUP(L212,I187:I212,J187:J212) Normal row ranges A A TRUE =LOOKUP(I269,G265:AF265) Name A B C D E F G H I J K L M N O P Q R S T U V W X Y Z B B TRUE =LOOKUP(I270,G265:AF265) Value Andy Bruce Charlie David Edward Frank George Henry Ira Jamie Kevin Leonard Michael Noel Oliver Peter Quincy Rachel Stuart Tom Uma Victor Wesley Xander Yoko Zebulon C C TRUE =LOOKUP(I271,G265:AF265) D D TRUE =LOOKUP(I272,G265:AF265) Formula E E TRUE =LOOKUP(I273,G265:AF265) A F F TRUE =LOOKUP(I274,G265:AF265) B G G TRUE =LOOKUP(I275,G265:AF265) C H H TRUE =LOOKUP(I276,G265:AF265) D I I TRUE =LOOKUP(I277,G265:AF265) E J J TRUE =LOOKUP(I278,G265:AF265) F K K TRUE =LOOKUP(I279,G265:AF265) G L L TRUE =LOOKUP(I280,G265:AF265) H M M TRUE =LOOKUP(I281,G265:AF265) I N N TRUE =LOOKUP(I282,G265:AF265) J O O TRUE =LOOKUP(I283,G265:AF265) K P P TRUE =LOOKUP(I284,G265:AF265) L Q Q TRUE =LOOKUP(I285,G265:AF265) M R R TRUE =LOOKUP(I286,G265:AF265) N S S TRUE =LOOKUP(I287,G265:AF265) O T T TRUE =LOOKUP(I288,G265:AF265) P U U TRUE =LOOKUP(I289,G265:AF265) Q V V TRUE =LOOKUP(I290,G265:AF265) R W W TRUE =LOOKUP(I291,G265:AF265) S X X TRUE =LOOKUP(I292,G265:AF265) T Y Y TRUE =LOOKUP(I293,G265:AF265) U Z Z TRUE =LOOKUP(I294,G265:AF265) V Andy Andy TRUE =LOOKUP(I269,G265:AF266) W Bruce Bruce TRUE =LOOKUP(I270,G265:AF266) X Charlie Charlie TRUE =LOOKUP(I271,G265:AF266) Y David David TRUE =LOOKUP(I272,G265:AF266) Z Edward Edward TRUE =LOOKUP(I273,G265:AF266) Frank Frank TRUE =LOOKUP(I274,G265:AF266) George George TRUE =LOOKUP(I275,G265:AF266) Henry Henry TRUE =LOOKUP(I276,G265:AF266) Ira Ira TRUE =LOOKUP(I277,G265:AF266) Jamie Jamie TRUE =LOOKUP(I278,G265:AF266) Kevin Kevin TRUE =LOOKUP(I279,G265:AF266) Leonard Leonard TRUE =LOOKUP(I280,G265:AF266) Michael Michael TRUE =LOOKUP(I281,G265:AF266) Noel Noel TRUE =LOOKUP(I282,G265:AF266) Oliver Oliver TRUE =LOOKUP(I283,G265:AF266) Peter Peter TRUE =LOOKUP(I284,G265:AF266) Quincy Quincy TRUE =LOOKUP(I285,G265:AF266) Rachel Rachel TRUE =LOOKUP(I286,G265:AF266) Stuart Stuart TRUE =LOOKUP(I287,G265:AF266) Tom Tom TRUE =LOOKUP(I288,G265:AF266) Uma Uma TRUE =LOOKUP(I289,G265:AF266) Victor Victor TRUE =LOOKUP(I290,G265:AF266) Wesley Wesley TRUE =LOOKUP(I291,G265:AF266) Xander Xander TRUE =LOOKUP(I292,G265:AF266) Yoko Yoko TRUE =LOOKUP(I293,G265:AF266) Zebulon Zebulon TRUE =LOOKUP(I294,G265:AF266) Andy Andy TRUE =LOOKUP(I269,G265:AF265,G266:AF266) Bruce Bruce TRUE =LOOKUP(I270,G265:AF265,G266:AF266) Charlie Charlie TRUE =LOOKUP(I271,G265:AF265,G266:AF266) David David TRUE =LOOKUP(I272,G265:AF265,G266:AF266) Edward Edward TRUE =LOOKUP(I273,G265:AF265,G266:AF266) Frank Frank TRUE =LOOKUP(I274,G265:AF265,G266:AF266) George George TRUE =LOOKUP(I275,G265:AF265,G266:AF266) Henry Henry TRUE =LOOKUP(I276,G265:AF265,G266:AF266) Ira Ira TRUE =LOOKUP(I277,G265:AF265,G266:AF266) Jamie Jamie TRUE =LOOKUP(I278,G265:AF265,G266:AF266) Kevin Kevin TRUE =LOOKUP(I279,G265:AF265,G266:AF266) Leonard Leonard TRUE =LOOKUP(I280,G265:AF265,G266:AF266) Michael Michael TRUE =LOOKUP(I281,G265:AF265,G266:AF266) Noel Noel TRUE =LOOKUP(I282,G265:AF265,G266:AF266) Oliver Oliver TRUE =LOOKUP(I283,G265:AF265,G266:AF266) Peter Peter TRUE =LOOKUP(I284,G265:AF265,G266:AF266) Quincy Quincy TRUE =LOOKUP(I285,G265:AF265,G266:AF266) Rachel Rachel TRUE =LOOKUP(I286,G265:AF265,G266:AF266) Stuart Stuart TRUE =LOOKUP(I287,G265:AF265,G266:AF266) Tom Tom TRUE =LOOKUP(I288,G265:AF265,G266:AF266) Uma Uma TRUE =LOOKUP(I289,G265:AF265,G266:AF266) Victor Victor TRUE =LOOKUP(I290,G265:AF265,G266:AF266) Wesley Wesley TRUE =LOOKUP(I291,G265:AF265,G266:AF266) Xander Xander TRUE =LOOKUP(I292,G265:AF265,G266:AF266) Yoko Yoko TRUE =LOOKUP(I293,G265:AF265,G266:AF266) Non-matching source and result ranges Zebulon Zebulon TRUE =LOOKUP(I294,G265:AF265,G266:AF266) Name Value Andy Bruce Charlie David Edward Name A B C D E Value Andy Andy TRUE =LOOKUP(H345,F343:F347,H342:L342) A Andy Bruce Bruce TRUE =LOOKUP(H346,F343:F347,H342:L342) B Formula Formula Bruce Charlie Charlie TRUE =LOOKUP(H347,F343:F347,H342:L342) C A A Charlie David David TRUE =LOOKUP(H348,F343:F347,H342:L342) D B B David Edward Edward TRUE =LOOKUP(H349,F343:F347,H342:L342) E C C Edward Andy Andy TRUE =LOOKUP(N345,O342:S342,T343:T347) D D Bruce Bruce TRUE =LOOKUP(N346,O342:S342,T343:T347) E E Charlie Charlie TRUE =LOOKUP(N347,O342:S342,T343:T347) David David TRUE =LOOKUP(N348,O342:S342,T343:T347) Non-vector source and result ranges Edward Edward TRUE =LOOKUP(N349,O342:S342,T343:T347) Name Value Formula Err:504 Err:504 TRUE =LOOKUP(J353,F353:G357,H353:I357) A F Andy Frank A Err:504 Err:504 TRUE =LOOKUP(J354,F353:G357,H353:I357) B G Bruce George B Err:504 Err:504 TRUE =LOOKUP(J355,F353:G357,H353:I357) C H Charlie Henry C Err:504 Err:504 TRUE =LOOKUP(J356,F353:G357,H353:I357) D I David Ira D Err:504 Err:504 TRUE =LOOKUP(J357,F353:G357,H353:I357) E J Edward Jamie E Err:504 Err:504 TRUE =LOOKUP(J358,F353:G357,H353:I357) F Err:504 Err:504 TRUE =LOOKUP(J359,F353:G357,H353:I357) G Err:504 Err:504 TRUE =LOOKUP(J360,F353:G357,H353:I357) H Err:504 Err:504 TRUE =LOOKUP(J361,F353:G357,H353:I357) I Err:504 Err:504 TRUE =LOOKUP(J362,F353:G357,H353:I357) J Frank Frank TRUE =LOOKUP(I365,F365:H369) Non-matching geometries George George TRUE =LOOKUP(I366,F365:H369) Name Value Formula Henry Henry TRUE =LOOKUP(I367,F365:H369) A Andy Frank A Ira Ira TRUE =LOOKUP(I368,F365:H369) B Bruce George B Jamie Jamie TRUE =LOOKUP(I369,F365:H369) C Charlie Henry C Err:504 Err:504 TRUE =LOOKUP(I365,F365:F369,G365:H369) D David Ira D Err:504 Err:504 TRUE =LOOKUP(I366,F365:F369,G365:H369) E Edward Jamie E Err:504 Err:504 TRUE =LOOKUP(I367,F365:F369,G365:H369) Err:504 Err:504 TRUE =LOOKUP(I368,F365:F369,G365:H369) Err:504 Err:504 TRUE =LOOKUP(I369,F365:F369,G365:H369) Name Value Formula Andy Andy TRUE =LOOKUP(I373,F373:H377) A F Andy A Bruce Bruce TRUE =LOOKUP(I374,F373:H377) B G Bruce B Charlie Charlie TRUE =LOOKUP(I375,F373:H377) C H Charlie C David David TRUE =LOOKUP(I376,F373:H377) D I David D Edward Edward TRUE =LOOKUP(I377,F373:H377) E J Edward E Edward Edward TRUE =LOOKUP(I378,F373:H377) F Edward Edward TRUE =LOOKUP(I379,F373:H377) G Edward Edward TRUE =LOOKUP(I380,F373:H377) H Edward Edward TRUE =LOOKUP(I381,F373:H377) I Edward Edward TRUE =LOOKUP(I382,F373:H377) J Andy Andy TRUE =LOOKUP(I373,F373:G377,H373:H377) Bruce Bruce TRUE =LOOKUP(I374,F373:G377,H373:H377) Charlie Charlie TRUE =LOOKUP(I375,F373:G377,H373:H377) David David TRUE =LOOKUP(I376,F373:G377,H373:H377) Edward Edward TRUE =LOOKUP(I377,F373:G377,H373:H377) Edward Edward TRUE =LOOKUP(I378,F373:G377,H373:H377) Edward Edward TRUE =LOOKUP(I379,F373:G377,H373:H377) Edward Edward TRUE =LOOKUP(I380,F373:G377,H373:H377) Edward Edward TRUE =LOOKUP(I381,F373:G377,H373:H377) Name A B C D E Edward Edward TRUE =LOOKUP(I382,F373:G377,H373:H377) Value Andy Bruce Charlie David Edward Frank Frank TRUE =LOOKUP(I396,G391:K393) Frank George Henry Ira Jamie George George TRUE =LOOKUP(I397,G391:K393) Henry Henry TRUE =LOOKUP(I398,G391:K393) Formula Ira Ira TRUE =LOOKUP(I399,G391:K393) A Jamie Jamie TRUE =LOOKUP(I400,G391:K393) B Err:504 Err:504 TRUE =LOOKUP(I396,G391:K391,G392:K393) C Err:504 Err:504 TRUE =LOOKUP(I397,G391:K391,G392:K393) D Err:504 Err:504 TRUE =LOOKUP(I398,G391:K391,G392:K393) E Err:504 Err:504 TRUE =LOOKUP(I399,G391:K391,G392:K393) Err:504 Err:504 TRUE =LOOKUP(I400,G391:K391,G392:K393) Andy Andy TRUE =LOOKUP(I408,G403:K405) Name A B C D E Bruce Bruce TRUE =LOOKUP(I409,G403:K405) F G H I J Charlie Charlie TRUE =LOOKUP(I410,G403:K405) Value Andy Bruce Charlie David Edward David David TRUE =LOOKUP(I411,G403:K405) Edward Edward TRUE =LOOKUP(I412,G403:K405) Formula Edward Edward TRUE =LOOKUP(I413,G403:K405) A Edward Edward TRUE =LOOKUP(I414,G403:K405) B Edward Edward TRUE =LOOKUP(I415,G403:K405) C Edward Edward TRUE =LOOKUP(I416,G403:K405) D Edward Edward TRUE =LOOKUP(I417,G403:K405) E Andy Andy TRUE =LOOKUP(I408,G403:K404,G405:K405) F Bruce Bruce TRUE =LOOKUP(I409,G403:K404,G405:K405) G Charlie Charlie TRUE =LOOKUP(I410,G403:K404,G405:K405) H David David TRUE =LOOKUP(I411,G403:K404,G405:K405) I Edward Edward TRUE =LOOKUP(I412,G403:K404,G405:K405) J Edward Edward TRUE =LOOKUP(I413,G403:K404,G405:K405) Edward Edward TRUE =LOOKUP(I414,G403:K404,G405:K405) Edward Edward TRUE =LOOKUP(I415,G403:K404,G405:K405) Square ranges Edward Edward TRUE =LOOKUP(I416,G403:K404,G405:K405) Name Value Formula Edward Edward TRUE =LOOKUP(I417,G403:K404,G405:K405) A D Andy A Andy Andy TRUE =LOOKUP(I422,F422:H424) B E Bruce B Bruce Bruce TRUE =LOOKUP(I423,F422:H424) C F Charlie C Charlie Charlie TRUE =LOOKUP(I424,F422:H424) D Charlie Charlie TRUE =LOOKUP(I425,F422:H424) E Charlie Charlie TRUE =LOOKUP(I426,F422:H424) F Charlie Charlie TRUE =LOOKUP(I427,F422:H424) Andy Andy TRUE =LOOKUP(I422,F422:G424,H422:H424) Bruce Bruce TRUE =LOOKUP(I423,F422:G424,H422:H424) Charlie Charlie TRUE =LOOKUP(I424,F422:G424,H422:H424) Charlie Charlie TRUE =LOOKUP(I425,F422:G424,H422:H424) Charlie Charlie TRUE =LOOKUP(I426,F422:G424,H422:H424) Charlie Charlie TRUE =LOOKUP(I427,F422:G424,H422:H424) Name A B C Formula C C TRUE =LOOKUP(J435,G434:I436) D E F A C C TRUE =LOOKUP(J436,G434:I436) Value Andy Bruce Charlie B C C TRUE =LOOKUP(J437,G434:I436) C F F TRUE =LOOKUP(J438,G434:I436) D Charlie Charlie TRUE =LOOKUP(J439,G434:I436) E Charlie Charlie TRUE =LOOKUP(J440,G434:I436) F Andy Andy TRUE =LOOKUP(J435,G434:I435,G436:I436) Bruce Bruce TRUE =LOOKUP(J436,G434:I435,G436:I436) Charlie Charlie TRUE =LOOKUP(J437,G434:I435,G436:I436) Ranges of different lengths Charlie Charlie TRUE =LOOKUP(J438,G434:I435,G436:I436) Name Value Formula Charlie Charlie TRUE =LOOKUP(J439,G434:I435,G436:I436) A Andy A Charlie Charlie TRUE =LOOKUP(J440,G434:I435,G436:I436) B Bruce B Andy Andy TRUE =LOOKUP(I445,F445:F449,G445:G447) C Charlie C Bruce Bruce TRUE =LOOKUP(I446,F445:F449,G445:G447) D OUT OF BOUND D Charlie Charlie TRUE =LOOKUP(I447,F445:F449,G445:G447) E OUT OF BOUND E OUT OF BOUND OUT OF BOUND TRUE =LOOKUP(I448,F445:F449,G445:G447) OUT OF BOUND OUT OF BOUND TRUE =LOOKUP(I449,F445:F449,G445:G447) Name Value Formula Andy Andy TRUE =LOOKUP(I452,F452:F456,G452:G455) A Andy A Bruce Bruce TRUE =LOOKUP(I453,F452:F456,G452:G455) B Bruce B Charlie Charlie TRUE =LOOKUP(I454,F452:F456,G452:G455) C Charlie C David David TRUE =LOOKUP(I455,F452:F456,G452:G455) D David D OUT OF BOUND OUT OF BOUND TRUE =LOOKUP(I456,F452:F456,G452:G455) E OUT OF BOUND E Andy Andy TRUE =LOOKUP(I459,F459:F461,G459:G463) Bruce Bruce TRUE =LOOKUP(I460,F459:F461,G459:G463) Name Value Formula Charlie Charlie TRUE =LOOKUP(I461,F459:F461,G459:G463) A Andy A Charlie Charlie TRUE =LOOKUP(I462,F459:F461,G459:G463) B Bruce B Charlie Charlie TRUE =LOOKUP(I463,F459:F461,G459:G463) C Charlie C Andy Andy TRUE =LOOKUP(I466,F466:F469,G466:G470) D David D Bruce Bruce TRUE =LOOKUP(I467,F466:F469,G466:G470) E Edward E Charlie Charlie TRUE =LOOKUP(I468,F466:F469,G466:G470) David David TRUE =LOOKUP(I469,F466:F469,G466:G470) Name Value Formula David David TRUE =LOOKUP(I470,F466:F469,G466:G470) A Andy A Andy Andy TRUE =LOOKUP(I475,F475:G484) B Bruce B Bruce Bruce TRUE =LOOKUP(I476,F475:G484) C Charlie C Charlie5 Charlie5 TRUE =LOOKUP(I477,F475:G484) D David D David David TRUE =LOOKUP(I478,F475:G484) E Edward E Edward Edward TRUE =LOOKUP(I479,F475:G484) Frank Frank TRUE =LOOKUP(I480,F475:G484) Andy Andy TRUE =LOOKUP(N475,K475:L482) Duplicate entries Case-sensitivity Bruce Bruce TRUE =LOOKUP(N476,K475:L482) Name Value Name Value Charlie Charlie TRUE =LOOKUP(N477,K475:L482) A Andy A a Andy A FALSE David David TRUE =LOOKUP(N478,K475:L482) B Bruce B B Bruce b FALSE Edward Edward TRUE =LOOKUP(N479,K475:L482) C Charlie1 C c Charlie C FALSE Frank Frank TRUE =LOOKUP(N480,K475:L482) C Charlie2 D D David d FALSE George George TRUE =LOOKUP(N481,K475:L482) C Charlie3 E e Edward E FALSE Henry Henry TRUE =LOOKUP(N482,K475:L482) C Charlie4 F F Frank f FALSE Andy Andy TRUE =LOOKUP(N475,K475:K482,L475:L482) C Charlie5 g George G FALSE Bruce Bruce TRUE =LOOKUP(N476,K475:K482,L475:L482) D David H Henry h FALSE Charlie Charlie TRUE =LOOKUP(N477,K475:K482,L475:L482) E Edward David David TRUE =LOOKUP(N478,K475:K482,L475:L482) F Frank Edward Edward TRUE =LOOKUP(N479,K475:K482,L475:L482) Frank Frank TRUE =LOOKUP(N480,K475:K482,L475:L482) George George TRUE =LOOKUP(N481,K475:K482,L475:L482) Henry Henry TRUE =LOOKUP(N482,K475:K482,L475:L482) c Value Target Formula 8 8 TRUE =LOOKUP(H489,F489:F528) 1 Res1 8.95370887542645 #N/A #N/A TRUE =LOOKUP(H490,F489:F528) 2 Res2 -5.40458751555081 14 14 TRUE =LOOKUP(H491,F489:F528) 3 Res3 14.2256297754681 22 22 TRUE =LOOKUP(H492,F489:F528) 4 Res4 22.5896448722584 25 25 TRUE =LOOKUP(H493,F489:F528) 5 Res5 25.5819104499515 12 12 TRUE =LOOKUP(H494,F489:F528) 6 Res6 12.6221489733041 #N/A #N/A TRUE =LOOKUP(H495,F489:F528) 7 Res7 -5.19531318050678 29 29 TRUE =LOOKUP(H496,F489:F528) 8 Res8 29.5088742428718 #N/A #N/A TRUE =LOOKUP(H497,F489:F528) 9 Res9 -0.666440755846702 40 40 TRUE =LOOKUP(H498,F489:F528) 10 Res10 47.5649568295371 28 28 TRUE =LOOKUP(H499,F489:F528) 11 Res11 28.1206428839629 40 40 TRUE =LOOKUP(H500,F489:F528) 12 Res12 45.5133833999322 39 39 TRUE =LOOKUP(H501,F489:F528) 13 Res13 39.6179907338434 40 40 TRUE =LOOKUP(H502,F489:F528) 14 Res14 40.966617076512 25 25 TRUE =LOOKUP(H503,F489:F528) 15 Res15 25.8259284242617 9 9 TRUE =LOOKUP(H504,F489:F528) 16 Res16 9.12267467377832 6 6 TRUE =LOOKUP(H505,F489:F528) 17 Res17 6.46759117691756 30 30 TRUE =LOOKUP(H506,F489:F528) 18 Res18 30.892568507333 28 28 TRUE =LOOKUP(H507,F489:F528) 19 Res19 28.5949305176141 23 23 TRUE =LOOKUP(H508,F489:F528) 20 Res20 23.4922334876289 9 9 TRUE =LOOKUP(H509,F489:F528) 21 Res21 9.9047020034232 6 6 TRUE =LOOKUP(H510,F489:F528) 22 Res22 6.75799561922819 2 2 TRUE =LOOKUP(H511,F489:F528) 23 Res23 2.95459644009574 29 29 TRUE =LOOKUP(H512,F489:F528) 24 Res24 29.7712581802436 #N/A #N/A TRUE =LOOKUP(H513,F489:F528) 25 Res25 -3.79379182727252 #N/A #N/A TRUE =LOOKUP(H514,F489:F528) 26 Res26 -6.14991564343158 14 14 TRUE =LOOKUP(H515,F489:F528) 27 Res27 14.3580858584808 3 3 TRUE =LOOKUP(H516,F489:F528) 28 Res28 3.4408361400043 5 5 TRUE =LOOKUP(H517,F489:F528) 29 Res29 5.1313509822275 40 40 TRUE =LOOKUP(H518,F489:F528) 30 Res30 47.6776164562826 #N/A #N/A TRUE =LOOKUP(H519,F489:F528) 31 Res31 -5.44916284816093 #N/A #N/A TRUE =LOOKUP(H520,F489:F528) 32 Res32 -3.54871178850439 #N/A #N/A TRUE =LOOKUP(H521,F489:F528) 33 Res33 0.781145098434259 40 40 TRUE =LOOKUP(H522,F489:F528) 34 Res34 44.3056317228615 #N/A #N/A TRUE =LOOKUP(H523,F489:F528) 35 Res35 -1.71122977764052 40 40 TRUE =LOOKUP(H524,F489:F528) 36 Res36 46.6919737925024 34 34 TRUE =LOOKUP(H525,F489:F528) 37 Res37 34.5542361657355 40 40 TRUE =LOOKUP(H526,F489:F528) 38 Res38 49.8330036884452 40 40 TRUE =LOOKUP(H527,F489:F528) 39 Res39 42.6088442205808 14 14 TRUE =LOOKUP(H528,F489:F528) 40 Res40 14.1387103236814 Res8 Res8 TRUE =LOOKUP(H489,F489:G528) #N/A #N/A TRUE =LOOKUP(H490,F489:G528) Res14 Res14 TRUE =LOOKUP(H491,F489:G528) Res22 Res22 TRUE =LOOKUP(H492,F489:G528) Res25 Res25 TRUE =LOOKUP(H493,F489:G528) Res12 Res12 TRUE =LOOKUP(H494,F489:G528) #N/A #N/A TRUE =LOOKUP(H495,F489:G528) Res29 Res29 TRUE =LOOKUP(H496,F489:G528) #N/A #N/A TRUE =LOOKUP(H497,F489:G528) Res40 Res40 TRUE =LOOKUP(H498,F489:G528) Res28 Res28 TRUE =LOOKUP(H499,F489:G528) Res40 Res40 TRUE =LOOKUP(H500,F489:G528) Res39 Res39 TRUE =LOOKUP(H501,F489:G528) Res40 Res40 TRUE =LOOKUP(H502,F489:G528) Res25 Res25 TRUE =LOOKUP(H503,F489:G528) Res9 Res9 TRUE =LOOKUP(H504,F489:G528) Res6 Res6 TRUE =LOOKUP(H505,F489:G528) Res30 Res30 TRUE =LOOKUP(H506,F489:G528) Res28 Res28 TRUE =LOOKUP(H507,F489:G528) Res23 Res23 TRUE =LOOKUP(H508,F489:G528) Res9 Res9 TRUE =LOOKUP(H509,F489:G528) Res6 Res6 TRUE =LOOKUP(H510,F489:G528) Res2 Res2 TRUE =LOOKUP(H511,F489:G528) Res29 Res29 TRUE =LOOKUP(H512,F489:G528) #N/A #N/A TRUE =LOOKUP(H513,F489:G528) #N/A #N/A TRUE =LOOKUP(H514,F489:G528) Res14 Res14 TRUE =LOOKUP(H515,F489:G528) Res3 Res3 TRUE =LOOKUP(H516,F489:G528) Res5 Res5 TRUE =LOOKUP(H517,F489:G528) Res40 Res40 TRUE =LOOKUP(H518,F489:G528) #N/A #N/A TRUE =LOOKUP(H519,F489:G528) #N/A #N/A TRUE =LOOKUP(H520,F489:G528) #N/A #N/A TRUE =LOOKUP(H521,F489:G528) Res40 Res40 TRUE =LOOKUP(H522,F489:G528) #N/A #N/A TRUE =LOOKUP(H523,F489:G528) Res40 Res40 TRUE =LOOKUP(H524,F489:G528) Res34 Res34 TRUE =LOOKUP(H525,F489:G528) Res40 Res40 TRUE =LOOKUP(H526,F489:G528) Res40 Res40 TRUE =LOOKUP(H527,F489:G528) Res14 Res14 TRUE =LOOKUP(H528,F489:G528) Numbers #N/A #N/A TRUE =LOOKUP(H570,MMULT(F570:F609,1)) Data Result Target Formula Excel XP Check 9 9 TRUE =LOOKUP(H571,MMULT(F570:F609,1)) 1 10 -4.53336217568421 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE 15 15 TRUE =LOOKUP(H572,MMULT(F570:F609,1)) 2 20 9.70396666611532 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE 9 9 TRUE =LOOKUP(H573,MMULT(F570:F609,1)) 3 30 15.3362479185479 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE #N/A #N/A TRUE =LOOKUP(H574,MMULT(F570:F609,1)) 4 40 9.97042805851738 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE #N/A #N/A TRUE =LOOKUP(H575,MMULT(F570:F609,1)) 5 50 -7.74641730083382 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE 20 20 TRUE =LOOKUP(H576,MMULT(F570:F609,1)) 6 60 -4.88469148891315 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE 40 40 TRUE =LOOKUP(H577,MMULT(F570:F609,1)) 7 70 20.1245073839552 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE 28 28 TRUE =LOOKUP(H578,MMULT(F570:F609,1)) 8 80 46.1170436051383 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE #N/A #N/A TRUE =LOOKUP(H579,MMULT(F570:F609,1)) 9 90 28.1648660630625 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE #N/A #N/A TRUE =LOOKUP(H580,MMULT(F570:F609,1)) 10 100 -0.170774662933884 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE 34 34 TRUE =LOOKUP(H581,MMULT(F570:F609,1)) 11 110 -4.49834467367032 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE 34 34 TRUE =LOOKUP(H582,MMULT(F570:F609,1)) 12 120 34.436579883806 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE 14 14 TRUE =LOOKUP(H583,MMULT(F570:F609,1)) 13 130 34.3306588586823 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE 35 35 TRUE =LOOKUP(H584,MMULT(F570:F609,1)) 14 140 14.0802711187292 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE 26 26 TRUE =LOOKUP(H585,MMULT(F570:F609,1)) 15 150 35.0222770395998 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE 20 20 TRUE =LOOKUP(H586,MMULT(F570:F609,1)) 16 160 26.4624259092933 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE 27 27 TRUE =LOOKUP(H587,MMULT(F570:F609,1)) 17 170 20.1644751694455 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE 25 25 TRUE =LOOKUP(H588,MMULT(F570:F609,1)) 18 180 27.9902591243144 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE 19 19 TRUE =LOOKUP(H589,MMULT(F570:F609,1)) 19 190 25.0144798916406 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE #N/A #N/A TRUE =LOOKUP(H590,MMULT(F570:F609,1)) 20 200 19.8866358021334 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE 10 10 TRUE =LOOKUP(H591,MMULT(F570:F609,1)) 21 210 -0.670167247409896 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE #N/A #N/A TRUE =LOOKUP(H592,MMULT(F570:F609,1)) 22 220 10.9670831874084 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE #N/A #N/A TRUE =LOOKUP(H593,MMULT(F570:F609,1)) 23 230 0.403603537805273 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE 4 4 TRUE =LOOKUP(H594,MMULT(F570:F609,1)) 24 240 -3.53003521441687 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE #N/A #N/A TRUE =LOOKUP(H595,MMULT(F570:F609,1)) 25 250 4.20377921192994 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE 40 40 TRUE =LOOKUP(H596,MMULT(F570:F609,1)) 26 260 -2.00473963604861 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE 29 29 TRUE =LOOKUP(H597,MMULT(F570:F609,1)) 27 270 44.1316543666094 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE 15 15 TRUE =LOOKUP(H598,MMULT(F570:F609,1)) 28 280 29.6571544709686 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE 18 18 TRUE =LOOKUP(H599,MMULT(F570:F609,1)) 29 290 15.5936793829992 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE 40 40 TRUE =LOOKUP(H600,MMULT(F570:F609,1)) 30 300 18.2048404349184 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE #N/A #N/A TRUE =LOOKUP(H601,MMULT(F570:F609,1)) 31 310 42.4175313332475 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE 10 10 TRUE =LOOKUP(H602,MMULT(F570:F609,1)) 32 320 -4.74515617634479 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE 40 40 TRUE =LOOKUP(H603,MMULT(F570:F609,1)) 33 330 10.5008121178258 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE 20 20 TRUE =LOOKUP(H604,MMULT(F570:F609,1)) 34 340 41.1554291672324 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE #N/A #N/A TRUE =LOOKUP(H605,MMULT(F570:F609,1)) 35 350 20.1494713890097 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE 19 19 TRUE =LOOKUP(H606,MMULT(F570:F609,1)) 36 360 0.638131464622695 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE 40 40 TRUE =LOOKUP(H607,MMULT(F570:F609,1)) 37 370 19.7687340594918 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE 7 7 TRUE =LOOKUP(H608,MMULT(F570:F609,1)) 38 380 41.416818269397 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE #N/A #N/A TRUE =LOOKUP(H609,MMULT(F570:F609,1)) 39 390 7.25184374767483 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE 1 1 TRUE =LOOKUP(H610,MMULT(F570:F609,1)) 40 400 -6.96293408546318 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE 40 40 TRUE =LOOKUP(H611,MMULT(F570:F609,1)) 1 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE #N/A #N/A TRUE =LOOKUP(H612,MMULT(F570:F609,1)) 40 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE #N/A #N/A TRUE =LOOKUP(H570,MMULT(F570:F609,1),MMULT(G570:G609,1)) 0 Err:502 Err:502 = TRUE TRUE TRUE FALSE FALSE 90 90 TRUE =LOOKUP(H571,MMULT(F570:F609,1),MMULT(G570:G609,1)) 150 150 TRUE =LOOKUP(H572,MMULT(F570:F609,1),MMULT(G570:G609,1)) 90 90 TRUE =LOOKUP(H573,MMULT(F570:F609,1),MMULT(G570:G609,1)) #N/A #N/A TRUE =LOOKUP(H574,MMULT(F570:F609,1),MMULT(G570:G609,1)) #N/A #N/A TRUE =LOOKUP(H575,MMULT(F570:F609,1),MMULT(G570:G609,1)) 200 200 TRUE =LOOKUP(H576,MMULT(F570:F609,1),MMULT(G570:G609,1)) 400 400 TRUE =LOOKUP(H577,MMULT(F570:F609,1),MMULT(G570:G609,1)) 280 280 TRUE =LOOKUP(H578,MMULT(F570:F609,1),MMULT(G570:G609,1)) #N/A #N/A TRUE =LOOKUP(H579,MMULT(F570:F609,1),MMULT(G570:G609,1)) #N/A #N/A TRUE =LOOKUP(H580,MMULT(F570:F609,1),MMULT(G570:G609,1)) 340 340 TRUE =LOOKUP(H581,MMULT(F570:F609,1),MMULT(G570:G609,1)) 340 340 TRUE =LOOKUP(H582,MMULT(F570:F609,1),MMULT(G570:G609,1)) 140 140 TRUE =LOOKUP(H583,MMULT(F570:F609,1),MMULT(G570:G609,1)) 350 350 TRUE =LOOKUP(H584,MMULT(F570:F609,1),MMULT(G570:G609,1)) 260 260 TRUE =LOOKUP(H585,MMULT(F570:F609,1),MMULT(G570:G609,1)) 200 200 TRUE =LOOKUP(H586,MMULT(F570:F609,1),MMULT(G570:G609,1)) 270 270 TRUE =LOOKUP(H587,MMULT(F570:F609,1),MMULT(G570:G609,1)) 250 250 TRUE =LOOKUP(H588,MMULT(F570:F609,1),MMULT(G570:G609,1)) 190 190 TRUE =LOOKUP(H589,MMULT(F570:F609,1),MMULT(G570:G609,1)) #N/A #N/A TRUE =LOOKUP(H590,MMULT(F570:F609,1),MMULT(G570:G609,1)) 100 100 TRUE =LOOKUP(H591,MMULT(F570:F609,1),MMULT(G570:G609,1)) #N/A #N/A TRUE =LOOKUP(H592,MMULT(F570:F609,1),MMULT(G570:G609,1)) #N/A #N/A TRUE =LOOKUP(H593,MMULT(F570:F609,1),MMULT(G570:G609,1)) 40 40 TRUE =LOOKUP(H594,MMULT(F570:F609,1),MMULT(G570:G609,1)) #N/A #N/A TRUE =LOOKUP(H595,MMULT(F570:F609,1),MMULT(G570:G609,1)) 400 400 TRUE =LOOKUP(H596,MMULT(F570:F609,1),MMULT(G570:G609,1)) 290 290 TRUE =LOOKUP(H597,MMULT(F570:F609,1),MMULT(G570:G609,1)) 150 150 TRUE =LOOKUP(H598,MMULT(F570:F609,1),MMULT(G570:G609,1)) 180 180 TRUE =LOOKUP(H599,MMULT(F570:F609,1),MMULT(G570:G609,1)) 400 400 TRUE =LOOKUP(H600,MMULT(F570:F609,1),MMULT(G570:G609,1)) #N/A #N/A TRUE =LOOKUP(H601,MMULT(F570:F609,1),MMULT(G570:G609,1)) 100 100 TRUE =LOOKUP(H602,MMULT(F570:F609,1),MMULT(G570:G609,1)) 400 400 TRUE =LOOKUP(H603,MMULT(F570:F609,1),MMULT(G570:G609,1)) 200 200 TRUE =LOOKUP(H604,MMULT(F570:F609,1),MMULT(G570:G609,1)) #N/A #N/A TRUE =LOOKUP(H605,MMULT(F570:F609,1),MMULT(G570:G609,1)) 190 190 TRUE =LOOKUP(H606,MMULT(F570:F609,1),MMULT(G570:G609,1)) 400 400 TRUE =LOOKUP(H607,MMULT(F570:F609,1),MMULT(G570:G609,1)) 70 70 TRUE =LOOKUP(H608,MMULT(F570:F609,1),MMULT(G570:G609,1)) #N/A #N/A TRUE =LOOKUP(H609,MMULT(F570:F609,1),MMULT(G570:G609,1)) 10 10 TRUE =LOOKUP(H610,MMULT(F570:F609,1),MMULT(G570:G609,1)) 400 400 TRUE =LOOKUP(H611,MMULT(F570:F609,1),MMULT(G570:G609,1)) #N/A #N/A TRUE =LOOKUP(H612,MMULT(F570:F609,1),MMULT(G570:G609,1)) #N/A #N/A TRUE =LOOKUP(H570,MMULT(F570:F609,1),G570:G609) 90 90 TRUE =LOOKUP(H571,MMULT(F570:F609,1),G570:G609) 150 150 TRUE =LOOKUP(H572,MMULT(F570:F609,1),G570:G609) 90 90 TRUE =LOOKUP(H573,MMULT(F570:F609,1),G570:G609) #N/A #N/A TRUE =LOOKUP(H574,MMULT(F570:F609,1),G570:G609) #N/A #N/A TRUE =LOOKUP(H575,MMULT(F570:F609,1),G570:G609) 200 200 TRUE =LOOKUP(H576,MMULT(F570:F609,1),G570:G609) 400 400 TRUE =LOOKUP(H577,MMULT(F570:F609,1),G570:G609) 280 280 TRUE =LOOKUP(H578,MMULT(F570:F609,1),G570:G609) #N/A #N/A TRUE =LOOKUP(H579,MMULT(F570:F609,1),G570:G609) #N/A #N/A TRUE =LOOKUP(H580,MMULT(F570:F609,1),G570:G609) 340 340 TRUE =LOOKUP(H581,MMULT(F570:F609,1),G570:G609) 340 340 TRUE =LOOKUP(H582,MMULT(F570:F609,1),G570:G609) 140 140 TRUE =LOOKUP(H583,MMULT(F570:F609,1),G570:G609) 350 350 TRUE =LOOKUP(H584,MMULT(F570:F609,1),G570:G609) 260 260 TRUE =LOOKUP(H585,MMULT(F570:F609,1),G570:G609) 200 200 TRUE =LOOKUP(H586,MMULT(F570:F609,1),G570:G609) 270 270 TRUE =LOOKUP(H587,MMULT(F570:F609,1),G570:G609) 250 250 TRUE =LOOKUP(H588,MMULT(F570:F609,1),G570:G609) 190 190 TRUE =LOOKUP(H589,MMULT(F570:F609,1),G570:G609) #N/A #N/A TRUE =LOOKUP(H590,MMULT(F570:F609,1),G570:G609) 100 100 TRUE =LOOKUP(H591,MMULT(F570:F609,1),G570:G609) #N/A #N/A TRUE =LOOKUP(H592,MMULT(F570:F609,1),G570:G609) #N/A #N/A TRUE =LOOKUP(H593,MMULT(F570:F609,1),G570:G609) 40 40 TRUE =LOOKUP(H594,MMULT(F570:F609,1),G570:G609) #N/A #N/A TRUE =LOOKUP(H595,MMULT(F570:F609,1),G570:G609) 400 400 TRUE =LOOKUP(H596,MMULT(F570:F609,1),G570:G609) 290 290 TRUE =LOOKUP(H597,MMULT(F570:F609,1),G570:G609) 150 150 TRUE =LOOKUP(H598,MMULT(F570:F609,1),G570:G609) 180 180 TRUE =LOOKUP(H599,MMULT(F570:F609,1),G570:G609) 400 400 TRUE =LOOKUP(H600,MMULT(F570:F609,1),G570:G609) #N/A #N/A TRUE =LOOKUP(H601,MMULT(F570:F609,1),G570:G609) 100 100 TRUE =LOOKUP(H602,MMULT(F570:F609,1),G570:G609) 400 400 TRUE =LOOKUP(H603,MMULT(F570:F609,1),G570:G609) 200 200 TRUE =LOOKUP(H604,MMULT(F570:F609,1),G570:G609) #N/A #N/A TRUE =LOOKUP(H605,MMULT(F570:F609,1),G570:G609) 190 190 TRUE =LOOKUP(H606,MMULT(F570:F609,1),G570:G609) 400 400 TRUE =LOOKUP(H607,MMULT(F570:F609,1),G570:G609) 70 70 TRUE =LOOKUP(H608,MMULT(F570:F609,1),G570:G609) #N/A #N/A TRUE =LOOKUP(H609,MMULT(F570:F609,1),G570:G609) 10 10 TRUE =LOOKUP(H610,MMULT(F570:F609,1),G570:G609) 400 400 TRUE =LOOKUP(H611,MMULT(F570:F609,1),G570:G609) #N/A #N/A TRUE =LOOKUP(H612,MMULT(F570:F609,1),G570:G609) Matrix of non-matching size Andy Andy TRUE =LOOKUP(F699,{"A","B","C"},{"Andy"}) Target Formula Excel XP #N/A #N/A TRUE =LOOKUP(F700,{"A","B","C"},{"Andy"}) A #N/A #N/A TRUE =LOOKUP(F701,{"A","B","C"},{"Andy"}) B Andy Andy TRUE =LOOKUP(F699,{"A"},{"Andy","Bruce","Charlie"}) C Andy Andy TRUE =LOOKUP(F700,{"A"},{"Andy","Bruce","Charlie"}) Andy Andy TRUE =LOOKUP(F701,{"A"},{"Andy","Bruce","Charlie"}) Case sensitivity Andy Andy TRUE =LOOKUP(I705,{"A","B","C","D","E","F"},{"Andy","Bruce","Charlie","David","Edward","Frank"}) Target Formula Bruce Bruce TRUE =LOOKUP(I706,{"A","B","C","D","E","F"},{"Andy","Bruce","Charlie","David","Edward","Frank"}) a Charlie Charlie TRUE =LOOKUP(I707,{"A","B","C","D","E","F"},{"Andy","Bruce","Charlie","David","Edward","Frank"}) B David David TRUE =LOOKUP(I708,{"A","B","C","D","E","F"},{"Andy","Bruce","Charlie","David","Edward","Frank"}) c Edward Edward TRUE =LOOKUP(I709,{"A","B","C","D","E","F"},{"Andy","Bruce","Charlie","David","Edward","Frank"}) D Frank Frank TRUE =LOOKUP(I710,{"A","B","C","D","E","F"},{"Andy","Bruce","Charlie","David","Edward","Frank"}) e Frank Frank TRUE =LOOKUP(I711,{"A","B","C","D","E","F"},{"Andy","Bruce","Charlie","David","Edward","Frank"}) F Frank Frank TRUE =LOOKUP(I712,{"A","B","C","D","E","F"},{"Andy","Bruce","Charlie","David","Edward","Frank"}) g Frank Frank TRUE =LOOKUP(I713,{"A","B","C","D","E","F"},{"Andy","Bruce","Charlie","David","Edward","Frank"}) H 7.33333333333333 7.33333333333333 TRUE =LOOKUP(4, I715:K715*2, I717:K717/3) z 2 2 TRUE =LOOKUP(2,I715) 1 1 TRUE =LOOKUP(1,1) 2 4 8 constants lookups 1 1 TRUE =LOOKUP(1,{1,2}) 22 22 TRUE =LOOKUP(2,I715,I717) 22 44 88 3 3 TRUE =LOOKUP(1,1,3) forced array 3 3 TRUE =LOOKUP(1,{1,2},{3,4}) Date Data Nov 1, 13 a Nov 2, 13 Nov 3, 13 b Nov 4, 13 Nov 5, 13 c Nov 6, 13 Nov 7, 13 d Nov 8, 13 4 41579 41580 41581 41582 41583 41584 41585 41586 a b c d