|
1
|
|
|
|
Introduction
|
|
|
14 位听众
|
|
2
|
|
|
|
Organize data properly for VLOOKUP
|
|
|
13 位听众
|
|
3
|
|
|
|
VLOOKUP Exact match
|
|
|
11 位听众
|
|
4
|
|
|
|
VLOOKUP Closest match
|
|
|
9 位听众
|
|
5
|
|
|
|
Improve error message with IFERROR
|
|
|
9 位听众
|
|
6
|
|
|
|
HLOOKUP
|
|
|
7 位听众
|
|
7
|
|
|
|
VLOOKUP Across sheets
|
|
|
6 位听众
|
|
8
|
|
|
|
XLOOKUP Simple example
|
|
|
6 位听众
|
|
9
|
|
|
|
XLOOKUP Match modes
|
|
|
5 位听众
|
|
10
|
|
|
|
XLOOKUP Combined with other functions
|
|
|
5 位听众
|
|
11
|
|
|
|
XLOOKUP Returns an array
|
|
|
5 位听众
|
|
12
|
|
|
|
XLOOKUP Search modes
|
|
|
5 位听众
|
|
13
|
|
|
|
Wrap up
|
|
|
2 位听众
|
