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 |
|