LXLogicExcel
🔥
0
0
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?
ABCDEFGH
1President:TrumpObamaBush Jr.ClintonBush Sr.ReaganCarter
2Year Elected:2016200820001992198819801976
3Years in Office:4888484
4
5
fx
🔥0streak
0 XP today
All Lessons