Fincom
Nexus
Feed
Set location
Back
How to play
Excel Formula Challenge
Question
1/8
Correct
0
Score
0 XP
Time
0:00
Question 1
You have a lookup table A2:C50 (ID, Name, City). What formula returns the City for the ID in E2?
A
=VLOOKUP(E2, A2:C50, 3, FALSE)
B
=VLOOKUP(E2, A2:C50, 2, FALSE)
C
=HLOOKUP(E2, A2:C50, 3, TRUE)
D
=INDEX(A2:C50, E2, 3)
Submit
Home
Jobs
Chat
Profile
More