★0 XP
Question 1 of 10
The HLOOKUP function in Excel is similar to VLOOKUP, but instead of searching a vertical list and returning a value from a corresponding column, it instead searches a horizontal list and returns a value from a corresponding row.
The first argument is the search value, the second argument is the range to search, the third argument is how many rows down to search from the lookup value, and the fourth argument is whether to use approximate match.
To get the value in the 3rd row where the value in the first row is "Clinton" we would write
=HLOOKUP("Clinton", A1:G3, 3, false)
What would this formula return?
The first argument is the search value, the second argument is the range to search, the third argument is how many rows down to search from the lookup value, and the fourth argument is whether to use approximate match.
To get the value in the 3rd row where the value in the first row is "Clinton" we would write
=HLOOKUP("Clinton", A1:G3, 3, false)
What would this formula return?
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | President: | Trump | Obama | Bush Jr. | Clinton | Bush Sr. | Reagan | Carter |
| 2 | Year Elected: | 2016 | 2008 | 2000 | 1992 | 1988 | 1980 | 1976 |
| 3 | Years in Office: | 4 | 8 | 8 | 8 | 4 | 8 | 4 |
| 4 | ||||||||
| 5 |
fx