assay
test suite

lookup

15 tests · 6 with documented divergences

Test Subject Formula Category DVs
69c3a1 INDEX =INDEX(A1:B2, 2, 1) value
94f29d INDEX =INDEX(A1:A3, 2) value
a6d07c INDEX =INDEX(A1:A2, 5) value
a353e6 MATCH =MATCH(20, A1:A3, 0) value
ca702a MATCH =MATCH(99, {1,2,3}, 0) value
0c3584 MATCH =MATCH(25, A1:A3, 1) value
ba9d81 VLOOKUP =VLOOKUP(2, A1:B3, 2, FALSE) value 1
0974ec VLOOKUP =VLOOKUP(99, A1:B2, 2, FALSE) value 1
ea1fcc HLOOKUP =HLOOKUP(2, A1:C2, 2, FALSE) value 1
c32154 XMATCH =XMATCH(20, A1:A3) value 1
1f28ea XMATCH =XMATCH(99, {1,2,3}) value
a8f9e7 XLOOKUP =XLOOKUP(2, A1:A3, B1:B3) value 1
63f481 XLOOKUP =XLOOKUP(99, A1:A2, B1:B2, "missing") value 1
b64c87 CHOOSECOLS =CHOOSECOLS({1,2,3;4,5,6}, 1, 3) value
7f7005 CHOOSEROWS =CHOOSEROWS({1,2;3,4;5,6}, 1, 3) value