From ba269f7294e2416659011cbb498a2c6b5f9d5199 Mon Sep 17 00:00:00 2001 From: Zdeněk Crhonek Date: Sun, 11 Sep 2016 21:49:47 +0200 Subject: add LOOKUP test case Change-Id: I64c1500b73d44297f0c714621e387591bc96761e Reviewed-on: https://gerrit.libreoffice.org/28821 Tested-by: Jenkins Reviewed-by: Markus Mohrhard --- sc/qa/unit/data/functions/fods/lookup.fods | 19515 +++++++++++++++++++++++++++ 1 file changed, 19515 insertions(+) create mode 100644 sc/qa/unit/data/functions/fods/lookup.fods (limited to 'sc') diff --git a/sc/qa/unit/data/functions/fods/lookup.fods b/sc/qa/unit/data/functions/fods/lookup.fods new file mode 100644 index 000000000000..2cefb0a94616 --- /dev/null +++ b/sc/qa/unit/data/functions/fods/lookup.fods @@ -0,0 +1,19515 @@ + + + + 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 + + + + + + + + + + \ No newline at end of file -- cgit