index-row-and-column |
INDEX |
=INDEX(A1:B2, 2, 1) |
value |
|
index-single-column |
INDEX |
=INDEX(A1:A3, 2) |
value |
|
index-out-of-bounds |
INDEX |
=INDEX(A1:A2, 5) |
value |
|
match-exact |
MATCH |
=MATCH(20, A1:A3, 0) |
value |
|
match-not-found |
MATCH |
=MATCH(99, {1,2,3}, 0) |
value |
|
match-approximate |
MATCH |
=MATCH(25, A1:A3, 1) |
value |
|
vlookup-exact |
VLOOKUP |
=VLOOKUP(2, A1:B3, 2, FALSE) |
value |
1 |
vlookup-not-found |
VLOOKUP |
=VLOOKUP(99, A1:B2, 2, FALSE) |
value |
1 |
vlookup-array-col-index |
VLOOKUP |
=VLOOKUP(2, A1:C3, {2,3}, FALSE) |
value |
2 |
hlookup-exact |
HLOOKUP |
=HLOOKUP(2, A1:C2, 2, FALSE) |
value |
1 |
hlookup-array-row-index |
HLOOKUP |
=HLOOKUP(2, A1:C3, {2;3}, FALSE) |
value |
2 |
xmatch-exact |
XMATCH |
=XMATCH(20, A1:A3) |
value |
1 |
xmatch-not-found |
XMATCH |
=XMATCH(99, {1,2,3}) |
value |
|
xlookup-basic |
XLOOKUP |
=XLOOKUP(2, A1:A3, B1:B3) |
value |
1 |
xlookup-not-found-with-default |
XLOOKUP |
=XLOOKUP(99, A1:A2, B1:B2, "missing") |
value |
1 |
choosecols |
CHOOSECOLS |
=CHOOSECOLS({1,2,3;4,5,6}, 1, 3) |
value |
|
chooserows |
CHOOSEROWS |
=CHOOSEROWS({1,2;3,4;5,6}, 1, 3) |
value |
|