★0 XP
Question 1 of 10
What would =XLOOKUP(2021, 1:1, 4:4) return?
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | STATE | 2020 | 2021 | 2022 | 2023 | 2024 |
| 2 | New York | 12 | 16 | 18 | 17 | 22 |
| 3 | Wisconsin | 2 | 5 | 4 | 5 | 6 |
| 4 | Texas | 8 | 7 | 8 | 8 | 9 |
| 5 | Ohio | 5 | 5 | 9 | 10 | 9 |
fx
Question 1 of 10
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | STATE | 2020 | 2021 | 2022 | 2023 | 2024 |
| 2 | New York | 12 | 16 | 18 | 17 | 22 |
| 3 | Wisconsin | 2 | 5 | 4 | 5 | 6 |
| 4 | Texas | 8 | 7 | 8 | 8 | 9 |
| 5 | Ohio | 5 | 5 | 9 | 10 | 9 |