★0 XP
Question 1 of 10
The XLOOKUP function is similar to VLOOKUP and has 3 required inputs.
The first is the lookup value, or the value XLOOKUP searches for. The second is the lookup range, or the range of cells where XLOOKUP searches for the lookup value. The third is the return range, or the corresponding range of cells which contains the value that XLOOKUP will return.
Type the following formula to find the number of scenes Andy was in:
=XLOOKUP("Andy", A:A, C:C)
The first is the lookup value, or the value XLOOKUP searches for. The second is the lookup range, or the range of cells where XLOOKUP searches for the lookup value. The third is the return range, or the corresponding range of cells which contains the value that XLOOKUP will return.
Type the following formula to find the number of scenes Andy was in:
=XLOOKUP("Andy", A:A, C:C)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | CHARACTER | EPISODES | SCENES | |
| 2 | Michael | 137 | 3033 | |
| 3 | Dwight | 186 | 2367 | |
| 4 | Jim | 185 | 2150 | |
| 5 | Pam | 182 | 1922 | |
| 6 | Andy | 144 | 1341 |
E2fx